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:
