Access ODBC error '80004005'

The error, “Operation must use an updateable query” can be a confusing error. However, my issue was very quickly fixed by giving the Internet Guest account write access to the directory containing the Access Database.

Log onto the server and open up Windows Explorer. Navigate to the directory that contains the database, right click it and select properties. Under the Security Tab select the Add button. Make sure that the Server Name is listed under From the Location (if not select locations and then the server). Then select the Advanced button. Next click Search (or Find Now depending on the Windows version). Then select the group named: IUSR_ + server name and hit the OK button twice. Finally select the recently added group and make sure that the Write permission is checked.

More information on the error can be found at the following:

• http://support.microsoft.com/kb/175168