Error message when you use the Database Editor page or the Submission Form page to update a database in FrontPage 2003: "The operation failed"

Consider the following scenario. You use the Database Interface Wizard in Microsoft Office FrontPage 2003 to create a data-driven Web site that uses a Microsoft Office Access 2003 database. Then, you publish the Web site to a Web server. Subsequently, you use a Web browser to connect to the Web site. Then, you use the Database Editor page or the Submission Form page to insert or update records in the database. However, you receive the following error message: If you turn on debugging in FrontPage 2003, you receive an error message that resembles the following:

This issue may occur if the database is not located in the correct folder on the Web server.

To resolve this issue, make sure that the database is located in the correct folder on the Web server. To do this, follow these steps:

1. Create a folder structure on the Web server that is the same as the folder structure on the local computer.
   
   For example, if the address of the Web site is http://ServerName/MyWebSite, the folder structure of the Web server may be Drive:\Inetput\Wwwroot\MyWebSite\Fpdb.
2. Copy the database to the correct location on the Web server.
   
   For example, copy the database to the Drive:\Inetput\Wwwroot\MyWebSite\Fpdb folder.
3. Use FrontPage 2003 to publish the Web site to the Web server.

For more information about how documents are opened from a Web site in Microsoft Office 2003, click the following article number to view the article in the Microsoft Knowledge Base: