I&#039m having trouble setting cursor types, lock optimistic, etc., for a recordset. The database works fine, and I can retrieve data reliably, and have adovbs.inc in the root. However, when I add a like such as adUseServer, I get an ADODB.Recordset error, arguments are wrong, out of range, etc.<BR><BR>Got any ideas? Here&#039s the code...<BR><BR>&#060;%<BR><BR>Dim objConn<BR><BR><BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR><BR>con nStr = "Driver={Microsoft Access Driver (*.mdb)}; dbq=d:InetPubwwwrootAmerican_machinerycgi-bin/fpdb/ammachdatabase.mdb; uid=; pw= ;"<BR><BR>objConn.open connStr<BR><BR>%&#062;<BR><BR><BR>&#060;%<BR><BR>D im objRS, StockID <BR><BR>StockID = (Stock1)<BR><BR><BR>Set objRS = Server.CreateObject ( "ADODB.Recordset" )<BR>objRS.CursorLocation = adUseServer<BR><BR><BR>sql = " SELECT * FROM Results WHERE (Stock = " & StockID & ") ; "<BR><BR>objRS.Open sql, connStr<BR><BR><BR>response.write objRS ("Make")<BR><BR>response.write objRS ("TimeStamp")<BR><BR>objRS.close : objConn.close<BR><BR>Set objRS = Nothing : Set objConn = Nothing<BR><BR>%&#062;