Provider = Jet 4 Sorting Error ?????

[vbCowboy]

Dim cn As New ADODB.Connection 
Dim rs As New ADODB.Recordset 
 
cn.open "Provider = Microsoft.Jet.OLEDB.4.0;" & _ 
"Data Source = C:\Program Files\Microsoft Visual Studio\VB98\Biblio.mdb" 
 
rs.open "SELECT * FROM Publishers Order By Name ASC",cn 
' rs.sort = "Name ASC"  **Change**

[vbCowboy]

Also as you can see by VB highlighting NAME, if that is a name of one of your fields you should change it. Try FirstName or LastName, you don't really want to use keywords as field names.

[Beacon]

or by putting it in [] in the sql statement!

tablename.[name]

b