You receive a database results error message when you connect to database from an ASP page in FrontPage (315456)

SYMPTOMS

When you attempt to browse to an Active Server Page (ASP) database results page created with Microsoft FrontPage, you may receive an error message similar to one of the following:

Database Results Error
[Microsoft][ODBC Microsoft Access Driver]
General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3f8 Thread 0x764 DBC 0x2150064 Jet'.

-or-

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.

RESOLUTION

To resolve this problem, correct the permissions to the folder specified in your system's %TEMP% variable.

Note The Microsoft Jet database engine uses the System %TEMP% environment variable to specify the location to place temporary files that are created during Jet operations. On Microsoft Windows NT 4.0 these environment variables are defined for users and are not system-wide settings by default. For more information, please see the "More Information" section later in this article.

To correct the permissions of your systems %TEMP% variable, follow these steps:

Locate your system's TEMP folder:
1. Follow the appropriate steps for your version of Windows:
  - For Windows XP: On the Start menu, click Control Panel, click the Performance and Maintenance icon, click the System icon, click the Advanced tab, and then click the Environment Variables button.
  - For Windows 2000: right-click My Computer on your desktop, click Properties on the menu that appears, click the Advanced tab, and then click the Environment Variables button.
  - For Windows NT: right-click My Computer on your desktop, click Properties on the menu that appears, and then click the Environment tab.
2. Find the TEMP variable in the list of System variables and note the folder that your system is using.
  
  Note An easier way to perform this task is to click Start , click Run, type %temp%, and then press Enter.
Start Windows Explorer.
In Folders view, expand the path to your temporary folder.
Right-click the folder and click Properties on the shortcut menu.
On the Security tab, add Everyone to the existing permissions, assign it Change permissions, and apply these new settings to all files and subfolders.
Click OK.

MORE INFORMATION

Windows NT 4.0 and TEMP Folders

To set up a system variable on a Windows NT 4.0 computer, follow these steps:

Right-click My Computer, and then click Properties on the shortcut menu.
Click the Environment tab.
Inspect the list to see whether the %TEMP% variable is present and correctly identified. If not, skip to step 4.
Select an entry in the System Variables List box, and then click New.
In the Variable box, type TEMP, and in the Variable Value box, type a valid path for your Windows Temp directory. (For example, type C:\Temp.)
Click OK to save the new variable.
Reboot your computer to apply the change.

REFERENCES

For additional information about troubleshooting ASP and Internet Information Service errors when working with the database connectivity features of FrontPage, click the article numbers below to view the articles in the Microsoft Knowledge Base:

265161 FP: Errors Appear When You Attempt to Connect to Database Results Page

219170 FP2000: Error Browsing Database Results Pages After Publishing from Disk-Based Web

For additional information about troubleshooting IIS permissions, click the following article numbers to view the articles in the Microsoft Knowledge Base:

185874 HOW TO: Troubleshoot Permissions in Internet Information Server 4.0

309051 How To Troubleshoot ASP in IIS 5.0