Microsoft KB Archive/308950

= FP2000: &quot;Server Encountered an Error&quot; Error Message When You Try to Connect to Microsoft Access Database =

Article ID: 308950

Article Last Modified on 1/7/2006

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q308950



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

 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Data Sources (ODBC), and then click the Drivers tab.
 * 3) 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&amp;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.</li> Close the Folder Properties dialog box.</li></ol>

<div class="references_section">