|
FAQ #1:Operation must
use an updateable query.
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.
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.
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
shows some other causes besides permissions.
|