FP2000: "Server Encountered an Error" Error Message When You Try to Connect to Microsoft Access Database (308950)

SYMPTOMS

When you use the Microsoft FrontPage 2000 Database Results Wizard to connect to a Microsoft Access database, the wizard may not retrieve the record source, and you may receive the following error message:

The server encountered an error while processing a
database request. For more information, click Details.

When you click Details, you receive additional information that is similar to the following:

Server error: Unable to connect to a database from the web server using
the connection string 'DRIVER={Microsoft Access Driver
(*.mdb)];DBQ=URL=fpdb/fpnwind.mdb'.

The following error message comes from the database driver software; it
may appear in a different language depending on how the driver is
configured.
-----------------------------------
Access is denied.
(ADODB.Connection)

Source:ADO
Number: -2147024891 (0x80070005)

CAUSE

This behavior may occur if one or both of the following conditions are true:

The latest Microsoft Access drivers are not installed on your computer.
The user who is currently logged on cannot access the files needed to make the changes because of incorrect permissions settings on the necessary folders.

RESOLUTION

To resolve this issue, use the following methods, as necessary, in the order presented.

Note Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

Method 1: Update the Microsoft Access Driver

Click Start, point to Settings, and then click Control Panel.
Double-click Data Sources (ODBC), and then click the Drivers tab.
Verify that the version of the Microsoft Access Driver (*.mdb) is 4.00 or later.

If your version is earlier than 4.00, visit the following Microsoft Web site to download the latest version:http://www.microsoft.com/downloads/-4e7d-b0b6-a8a94c4eb912&DisplayLang=en

Method 2: Change Permissions on the Files and Folders Necessary to Connect to the Database

Note The following steps apply only to the NTFS file system.

Start Microsoft Windows Explorer.
Find and then click the following folder:
C:\Program Files\Common Files\System\ado
On the File menu, click Properties.
Verify that the Everyone group has Read and Execute (RX) permissions.
Find the following folder, and then click Properties on the File menu:
C:\WINNT
Verify that the Everyone group has Read, Write, and Execute (RWX) permissions.
Close the Folder Properties dialog box.