FP2000: FrontPage 2000 Creates Access 2000 Database Files

ID: Q233406

The information in this article applies to:

SUMMARY

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.


MORE INFORMATION

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 editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

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: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).
  1. Start Registry Editor (Regedit.exe) on the Web server where the databases are to be created.


  2. Locate the DAO.DBEngine.36 key under the following key in the Registry:
    HKEY_CLASSES_ROOT


  3. On the Edit menu, click Rename, type DAO.DBEngine.36.Save, and then click OK.


  4. Quit Registry Editor.


This will make the application use DAO.DBEngine.35 (Access 97) instead of the DAO.DBEngine.36 (Access 2000).

Additional query words: front page 


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: July 1, 1999