text: operation must use an updateable query? i get this error message online on my webserver that supports asp. i am using access database and i am inserting data from a form page. i causes me to give this message. i have sorted the permissions issue, put the db in root directory, correctly put the system dsn  please help urget *** it appears your recordset is not the updateable type.  the standard syntax might be:  myrst.open mysqlsyntax, myconnection, option 1, option 2  the option 1 and 2 are where you set the recordset type - for your operation you would want dynamic and optimistic locking.  in addition, you usually need to tell the recordset you are adding first, like this:  myrst.addnew  otherwise the update method won't work.  hope these ideas help.