|
Question:
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.asp, line xxx
|
Answer:
Issue
The
following error: 80004005 – Operation must use an updateable query
– occurs on a page when ASP script attempts to update or insert
data into a recordset
Solution
There are
several possible reasons for this ODBC error:
|
|
Inappropriate permissions set on the directory containing the
database. 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:
Q174640 - PRB: ASP: "The query is
Not Updateable..." Error when Updating
Also you
can check
Troubleshooting "Operation must use an updateable query"
errors article.
|
