Summary
When your ASP code tries to insert into an Access Database file, you receive one of the following errors:
- Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. - [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
DETAILS
This error means that the anonymous user does not have adequate permissions to the database file. This problem typically happens when you have FrontPage extension enabled. FrontPage extensions automatically tightens the anonymous user permission to only allow Read Access. To resolve the problem, the database file must be uploaded using the FrontPage client rather than using FTP.
