Updating multiple tables in MS Access

<i><b>Originally posted by : shyam (shyamj@institute.net)</b></i><br />Hi,<br /><br />I have problem while working with ASP.<br />I am updating an MS Access Database which involves 2 tables related by primary key and foreign key.<br /><br />At the point,when I write recordset.update, <br />The error I get is::<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 /><br />The cursor type I am using is adopendynamic and the lock type i am using is adlockoptimistic.<br /><br /><br />Kindly help me.<br />Shyam<br /><br /><br />