The online FAQ database contains hundreds of answers to frequently asked questions, articles on using our web server applications and other related technologies, and resolutions to common problems. If you are seeing an error message, be sure to try searching on the error message or error number that you are seeing.

Question I get one of the error messages below when I click on a button or link.
  [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.
  [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Answer This message usually occurs for one of a couple different reasons. The most common reason is the folder that the MDB file is located in does not have proper filesystem permissions. Both the MDB file itself as well as the folder it is located in must have the proper permissions when accessed via the IIS web server's anonymous user account. See FAQ Article #390 for detailed information about filesystem permissions.

This can also occur if the MDB file is set to read-only mode. This file must have read/write access. This can occur with users who use Microsoft FrontPage to upload the files for the application to their web site. We recommend using FTP to upload the application files to your web site. This can also occur if you upload or copy the site from a CD-ROM copy. When files are stored on a CD-ROM, they are set as being read-only, and when you copy them to your server's hard disk, the read-only attribute is maintained and must be reset to allow read-write access to the MDB file. If you do not know how to reset file read/write permissions, you will need to ask your ISP or web host for assistance as the procedures for doing that can vary depending on your host.