Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive a �Debug messages: Operation must use an updateable query� error message when you submit a new record in a Web page database that you created in FrontPage 2003


View products that this article applies to.

Symptoms

When you open a database interface Web page in your Internet browser, and you try to submit a new record to the database, you receive an error message that is similar to the following:
Debug messages: Operation must use an updateable query.

↑ Back to the top


Cause

This problem may occur if the following conditions are true:
  • You used the Database Interface Wizard in Microsoft Office FrontPage 2003 to create the database interface Web page.
  • You set ASP.NET as the technology to use to connect to the database.
  • The database is on a Microsoft Windows Server 2003-based Internet Information Server (IIS).
  • A Microsoft Access Database (MDB) is used as the database source.
This problem occurs when a Microsoft Access database file is used as your database source because you must grant write access to both the default worker process identity and the authenticated user. By default, both Internet Information Server version 5.0 and Internet Information Server version 6.0 typically grant write access to both the default worker process identity and the authenticated user. However, when you use an MDB file as your database, these permissions must be granted by an administrator on the server that hosts the Web site.

↑ Back to the top


Workaround

To work around this problem, grant write access permission for the MDB file to both the IIS_WPG group and the Network Service. To do this, follow these steps:
  1. Log on as an administrator to the Microsoft Windows Server 2003-based computer that hosts your Web site.
  2. Click Start, right-click My Computer, and then click Explore.
  3. Expand the folder tree to the location of your Web site database file. For example, this file may be located in the following location:
    C:\Documents and Settings\Administrator\My Documents\My Web Sites\Your_Web_Site_Name\fpdb
  4. Right-click Your_Web_Site_Database_Name.mdb, and then click Properties.
  5. Click the Security tab, and then click Add.
  6. In the Enter the object names to select box, type IIS_WPG, and then click OK.
  7. In the Group or user names list, click IIS_WPG.
  8. In the Permissions for IIS_WPG list, click to select the Allow check box that is next to Write.
  9. Click Add.
  10. In the Enter the object names to select box, type Network Service, and then click OK.
  11. In the Group or user names list, click Network Service.
  12. In the Permissions for Network Service list, click to select the Allow check box that is next to Write.
  13. Click Apply, and then click OK.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

↑ Back to the top


Keywords: KB830977, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 830977
Revision : 7
Created on : 10/23/2006
Published on : 10/23/2006
Exists online : False
Views : 304