The information in this article applies to:
SUMMARYFrontPage 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.
Method 1: Create the Database Using AccessCreate 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 SoftwareIf 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 97IMPORTANT: 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).
Additional query words: front page
Keywords : kbdta fpodbc |
|
Last Reviewed: November 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |