Errors when modifying an Access database

Symptoms: If NT file permissions are not set correctly on an Access database, you might encountered the following errors when trying to use ASP to modify the database:

• Operation must use an updateable query.
• Could not delete from specified tables.

Solutions on Toons: As a first step run FixHTMLPermissions in the public folder in order to set the correct permissions on your ASP pages and on your database file. If the problem continues:

• Go to the U drive and find your username. Navigate to the database file in question, right click, and select properties. In the dialog that pops up, modify security by adding IUSR with full control. This requires several steps:
  • In the dialog select the Security tab
  • Select the Permissioins button
  • Select the Add button
  • Select the Show Users button
  • Select IUSR from the list
  • In the Type of Access drop down list select full control
  • Click your way out