SYMPTOMS
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:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.
If you turn on debugging in FrontPage 2003, you receive an error message that resembles the following:
Debug messages:
Database Results Wizard
Error
Description: Could not find file 'Drive:\FolderName\DatabaseName.mdb'.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine
RESOLUTION
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:
- 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. - Copy the database to the correct location on the Web server.
For example, copy the database to the Drive:\Inetput\Wwwroot\MyWebSite\Fpdb folder. - Use FrontPage 2003 to publish the Web site to the Web server.