PROBLEM:

When trying to save anything to the database, like adding a product to the cart, saving a product, changes settings in control panel, etc, the following error is displayed:

ASP Error occurred 12/3/2004 12:25:01 PM in Microsoft JET Database Engine
Error number: -2147217911 (0x80040E09)
File: XXXXX, line XXX
Cannot update.  Database or object is read-only.

This error normally happens on Access databases.

RESOLUTION:

This error is caused by the web server scripts not being able to modify the database.

When using an Access database the user used by the web server IIS (normally IUSR_machinename) must have read/write permissions over the database folder to be able to modify and update the database. Add read/write permissions to correct this error.

Check that the database file is not flagged as read only.

If using SQL Server, make sure the database account used has write permissions on all the tables.