Question: 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 \nPLEASE HELP URGET ***

Answer: It appears your recordset is not the updateable type.  The standard syntax might be:\n\nMyRst.Open MySQLSyntax, MyConnection, option 1, option 2\n\nThe option 1 and 2 are where you set the recordset type - for your operation you would want dynamic and optimistic locking.\n\nIn addition, you usually need to tell the recordset you are adding first, like this:\n\nMyRst.AddNew\n\nOtherwise the Update method won't work.\n\nHope these ideas help.
This question from the Yahoo Q&A forum is categorized in the topic: Society & Culture