FrontPage 2000 creates Access 2000 database files (233406)
The information in this article applies to:
This article was previously published under Q233406 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 97IMPORTANT: 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:
HKEY_CLASSES_ROOT
- 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).
| Modification Type: | Minor | Last Reviewed: | 9/27/2004 |
|---|
| Keywords: | kbregistration kbwizard kbnewfile kbDatabase kbinfo KB233406 |
|---|
|