Errors Creating or Browsing Database

ID: Q243331

The information in this article applies to:

Microsoft FrontPage 2000 Server Extensions

SYMPTOMS

When you attempt to create a database connection in a FrontPage web, one of the following error message may occur:

Server error: Unable to retrieve the list of record sources from a database using the connection string:

DSN=fpdb;DRIVER={Microsoft Access Driver (*.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.
-------------------------------------------------------

Source: ADO
Number: -2146824584 (0x800a0e78)

-OR-

Server error: Unable to retrieve the list of record sources from a database using the connection string:

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/new_page_2.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.
-------------------------------------------------------

Source: ADO
Number: -2146824584 (0x800a0e78)

When you browse to an ASP page with a database region, the following error message occurs in the browser:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

CAUSE

This is by design. The error occurs because the permissions in the Winnt folder are too restrictive.

RESOLUTION

Give the local Everyone group at least Add and Read permissions on the Winnt folder.

Note: If you are editing in a subweb and using the Global.asa file in the root Web, the author's user account, as well as any anonymous account in use, must have at least browse access explicitly specified on the root Web.

MORE INFORMATION

The Jet Database Engine writes temporary files to the Winnt folder as the account accessing the Web. In the case of Authoring, the account is the logged on user, and in the case of browsing, it is the Iusr_machinename account.

Additional query words: front page

Keywords : fpse2000
Version : winnt:
Platform : winnt
Issue type : kbprb