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

When I was using DNS-System Connections I have not problems with paging data but I have to use DNS-Less Connection now and the Access database Engine says: Microsoft JET Database Engine error 80040e07

When you use a DSN-less connection against a MSAccess database you cannot use neither MSAccess...

I get a '[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.' error when trying to access my ASP or ASP.net application. What does this mean?

This error usually occurs if the MS Access database you are trying to connect to is of MS Access...

Where should I upload my Access database files?

The information in this article applies to: Microsoft Access DETAILS You should see a...