[KB_41] - Error '80004005' Operation must use an updateable query.
SUMMARY: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
You recieve this error anytime one of our scripts tries to write information to the database.
This error will appear anytime you try to write information to the database.
It usually appears on a newly installed copy of the script.
It may appear if you move the script to a different folder on your server or to a different host.
CAUSE: This error is a permission problem caused by Microsoft Access. Access needs to create a lock file (.ldb) in the folder that the database file is in... In many cases the credentials that the web server is using doesn't have the appropriate permissions to the folder the database resides in to do so.
You can easily correct this problem by granting the default IIS user on your server "FULL CONTROL" over the folder that the database file resides in.
If you are running the script on a web hosts server you may have a utility that is part of a web based control panel that allows you to set permissions on files and folders... if so you can use that utility to correctly set the permissions on the folder.
Most web hosts already have a "database" or "db" folder setup on your hosting account that already has the correct permissions set on the folder. If so you should move your database file to that folder and change the connection string in the db.asp file to reflect that new location.