I receive error '80004005' when my ASP or ASP.NET code tries to insert into an Access Database. How do I resolve this?

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.

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.

By default, the database folder located underneath your domain name has write and read access for anonymous users, but if you use Front Page Extension, it will render the site security setting and remove the permission.

Was this answer helpful?

 Print this Article

Also Read