The Recordset returns no records. There ARE records in the table. I can use cn.Execute "INSERT .." and it works - this tells me the connection is ok. I included the code below. I tried every possible syntax variation with the same result: Recordset comes back empty (EOF and BOF is true). Also, if I specify an Access db the recordset comes back with records. Any ideas?<BR><BR>Thanks.<BR><BR>strDSN = "dsn=dsn_name;uid=uid;pwd=pwd"<BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>&#039;c n.CursorLocation = adUseClient<BR>cn.Open strDSN<BR><BR>Set Rs = Server.CreateObject("ADODB.Recordset")<BR>&#039;Rs .CursorLocation = adUseClient<BR><BR>SQL = "Select * from table_name"<BR><BR>&#039;this works!<BR>&#039;SQL = "INSERT INTO table(doc_id) VALUES (132)" <BR>&#039;RS = cn.Execute(SQL)<BR><BR>&#039;neither returns records<BR>Set RS = cn.Execute(SQL)<BR>&#039;Rs.Open SQL, cn&#039;, adOpenStatic, adLockBatchOptimistic<BR>