I receive error '80004005' when my ASP or ASP.NET code tries to insert 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.

  • 13 Users Found This Useful
Was this answer helpful?

Related Articles

Where do I upload my Access database files?

You should see a directory named "_database" under your webroot. The _database directory is...

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

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

Is Microsoft Remote Data Services (RDS) supported?

Microsoft Remote Data Services (RDS) is not supported. RDS is a deprecated technology and is no...

Do you support Data Access Page (DAP)?

Data Access Page is not a supported feature. Data Access Page is designed to be used in an...