ADODB.Recordset error &#039 800a0cb3&#039<BR><BR>I&#039ve seen numerous posts, where people get this error, but I haven&#039t seen a conclusive/complete answer for what is going on.<BR><BR>I see this error when adding records, updating records, trying to use the "page" commands, etc.<BR><BR>Here&#039s an example of adding a record:<BR><BR><BR>connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Databaseswing.mdb;Persist Security Info=False"<BR>password = ""<BR>user = "admin"<BR><BR>&#039 Create a connection to the SQL server <BR>Set objConnection = Server.CreateObject("ADODB.Connection")<BR>objConn ection.Open connection, user, password<BR><BR>&#039 Create a recordset object<BR>Set RS = Server.CreateObject("ADODB.RecordSet")<BR>RS.Open "SELECT lastName FROM Reviewers", objConnection,adOpenDynamic<BR><BR>&#039 Check to see if AddNew is supported <BR>if RS.Supports(adAddNew ) then<BR><BR>&#039 Add a record<BR>Write("<BR>" & "Supports Add New" )<BR>RS.AddNew<BR><BR>End If<BR><BR><BR>