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:
Operation must use an updateable query.
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.
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:
- Log on as an administrator to the Microsoft Windows Server 2003-based computer that hosts your Web site.
- Click Start, right-click My Computer, and then click Explore.
- 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
- Right-click Your_Web_Site_Database_Name.mdb, and then click Properties.
- Click the Security tab, and then click Add.
- In the Enter the object names to select box, type IIS_WPG, and then click OK.
- In the Group or user names list, click IIS_WPG.
- In the Permissions for IIS_WPG list, click to select the Allow check box that is next to Write.
- Click Add.
- In the Enter the object names to select box, type Network Service, and then click OK.
- In the Group or user names list, click Network Service.
- In the Permissions for Network Service list, click to select the Allow check box that is next to Write.
- Click Apply, and then click OK.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.
Article ID: 830977 - Last Review: January 10, 2015 - Revision: 3.0
|kbnosurvey kbarchive kberrmsg kbprb KB830977|