Error: Operation must use an updateable query.

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 does 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

go to the folder where the db is stored and right click select security and add isusr make sure you untick the propogate field and give read / write access to the folder.

Rob. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=349&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />