Database or object is read-only when adding record

<i><b>Originally posted by : Al Moroz (amoroz@abacus-strategies.com)</b></i><br />Am trying to take information from a form and add the record to an Access 2000 database using a RecordSet but the following error returns when I attempt to do rst.Update<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />/ASP/CustomerAdd2.asp, line 100<br /><br />Below are the connection and recordset lines of code:<br />cnn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("aspasp test.mdb"))<br /><br />rst.Open "tblCustomers", cnn, 2, 2<br /><br />Any suggestions? Do I have to include the default user 'Admin' in the cnn string?

<i><b>Originally posted by : Cander</b></i><br />TRy this<br /><br />rst.CursorType = adOpenKeyset<br />rst.LockType = adLockOptimistic<br />rst.Open "tblCustomers", conn<br /><br /><br />------------<br />Al Moroz at 8/2/2000 2:23:39 AM<br /><br />Am trying to take information from a form and add the record to an Access 2000 database using a RecordSet but the following error returns when I attempt to do rst.Update<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <br /><br />/ASP/CustomerAdd2.asp, line 100<br /><br />Below are the connection and recordset lines of code:<br />cnn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("aspasp test.mdb"))<br /><br />rst.Open "tblCustomers", cnn, 2, 2<br /><br />Any suggestions? Do I have to include the default user 'Admin' in the cnn string?