This article was previously published under Q233406
This article has been archived. It is offered "as is" and will no longer be updated.
FrontPage 2000 creates an Access 2000 database file for the Save Results to Database form handler. Because FrontPage offers the capability to read, write, and edit data with the Database Results Wizard and the Save to Database form handler, you do not need to open the database file directly. If you want to open the database file directly instead of manipulating it through the Database Results Wizard, you will need Access 2000, or you will need to implement one of the workarounds described in the More Information section of this article.
FrontPage 2000 will always use the latest version of the Microsoft Access database components on the computer when you create a database for the Save Results Wizard. FrontPage Setup installs the Access 2000 database components, so FrontPage 2000 always generates Access 2000 file formats within the Web. This is only true when FrontPage creates the database file. FrontPage can connect to most popular Database Management Systems if you create the data connection manually.
The following three methods will allow you to use the Save to Database form handler data to store data in different file formats.
Method 1: Create the Database Using Access
Create the database file using your version of Access and then import it to the web. Because the file has a .MDB file extension, FrontPage will automatically create a database connection for you. Use this database connection as the source for your database interaction.
Method 2: Create the Database Using Your Database Management Software
If you do not have Microsoft Access, but you do have a database management system with the latest ODBC drivers, you may use your database management system to create the database, then create a database connection that is directed to the file from within FrontPage.
For more information about creating database connections, click Microsoft FrontPage Help on the Help menu, type create a database connection in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Method 3: Edit the Registry To Force FrontPage 2000 to Use Access 97
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
This workaround has not been fully regression tested and may lead to problems with other database access technologies. Also note that if you choose to Repair or Reinstall, the FrontPage 2000 installation, will rewrite the following registry key to the default state. Also, note that the FrontPage sample database is an Access 2000 database, regardless of this registry key. This fix only affects new databases that you create with the FrontPage 2000 Save to Database form handler.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
Start Registry Editor (Regedit.exe) on the Web server where the databases are to be created.
Locate the DAO.DBEngine.36 key under the following key in the Registry:
On the Edit menu, click Rename, type DAO.DBEngine.36.Save, and then click OK.
Quit Registry Editor.
This will make the application use DAO.DBEngine.35 (Access 97) instead of the DAO.DBEngine.36 (Access 2000).