I receive the following error message when trying
to save changes I made to database:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.
/tablename_edit.aspx, line xxx
Answer:
Issue
The
following error: 80004005 – Operation must use an updateable
query – occurs on a page when an event is updating or inserting
into a recordset.
Solution
There
are several things that may cause this ODBC error. Many of the
possible reasons are listed in the table below.
The
permissions that are set on the directory the database is in. IUSR
privileges must be set to "read/write".
The
permissions on the database itself do not have full read/write
privileges in effect.
This
error can also occur when the database is located outside of the
inetpub/wwwroot directory. Though the information is still able to be
viewed and searched, it cannot be updated unless it is in the wwwroot directory.
Additional information
For
additional information on this error, please refer to following
article in Microsoft's Knowledge Base:
