Niq
08-21-02, 08:57
| I have this statement which works: strSQL="select * from " & Table_Name objRS.open strSQL, objConn But when I want to sort according to my column 'Position' (which is of number type under Access 2000) It no longer works. Any Idea?: strSQL="select * from " & Table_Name & " Order by Position" objRS.open strSQL, objConn I have this error: error '80004005' Unspecified error I'm connected this way: StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"&_ "Data Source=o:\teams\pursuit\db\productdb.mdb;" &_ "Persist Security Info=False" Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = StrConnect objConn.Open Set objRS = Server.CreateObject("ADODB.Recordset") objRS.activeconnection = objConn Help :confused: |