I got error '80004005' when my ASP or ASP.NET code tries to insert data into an Access database.

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 up-datable query.

* [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

This error means that the anonymous user does not have adequate permissions to access the database file. This problem typically occurs when you have FrontPage extension enabled. FrontPage extensions automatically tighten the anonymous user permission to allow only Read Access. To resolve the problem, the database file must be uploaded using the FrontPage client rather than using FTP.

Article ID: 32, Created On: 2/27/2012, Modified: 2/27/2012

Feedback (0)