I get this error message when adding or modifying data
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Database Error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
This is a very common error message when updating Access databases.
Since Access is file based any attempt to update the database by an ASP script can only modify the Access databases if permissions are established correctly.
Go to the parent directory where the database is stored. Click on the folder permissions and set IUSER_xxxxx to ‘change’ where xxxxx is the machine name. Make sure the file is also set so the ISUSER_xxxx can change the file.
More information may be found in this Microsoft article http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP.
