Error: Operation must use an updateable query - ASP.NET: Solved

Error:
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

Solution:

possible reasons:

+ 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.

Related Posts :