JSI Tip 7416. When you try to submit a new record on a database interface Web page in your browser, Windows Server 2003 displays a message similar to 'Debug messages: Operation must use an updateable query'?

The subject behavior will occur if all of the following are true:

  • You used the Database Interface Wizard in Microsoft Office FrontPage 2003 to create the database interface Web page.
  • The database is on a Windows Server 2003 IIS server.
  • ASP .NET is used to connect to the database.
  • Microsoft Access is the database source.
When using a MDB file, you must manually grant IIS_WPG  and the Network Service write access to the MDB file:

01. Logon to the Windows Server 2003 computer with administrative privileges.

02. Use My Computer or Windows Explorer to navigate to the database file.

03. Right-click the MDB file and press Properties.

04. Select the Security tab.

05. Press the Add button.

06. Type IIS_WPG into the Enter the object names to select box and press OK.

07. In the Group or user names list, select IIS_WPG.

08. In the Permissions for IIS_WPG list, check Allow for Write.

09. Press the Add button.

10. Type Network Service into the Enter the object names to select box and press OK.

11. In the Group or user names list, select Network Service.

12. In the Permissions for Network Service list, check Allow for Write.

13. Press Apply and OK.



Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish