Microsoft KB Archive/315456

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

Article ID: 315456

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition
 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q315456



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.



CAUSE
This behavior can occur if incorrect NTFS permissions are defined for your system %TEMP% folder.



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 &quot;More Information&quot; section later in this article.

To correct the permissions of your systems %TEMP% variable, follow these steps:  Locate your system's TEMP folder:  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. </li> 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.</li></ol> </li> Start Windows Explorer.</li> In Folders view, expand the path to your temporary folder.</li> Right-click the folder and click Properties on the shortcut menu.</li> On the Security tab, add Everyone to the existing permissions, assign it Change permissions, and apply these new settings to all files and subfolders.</li> Click OK.</li></ol>

<div class="moreinformation_section">

Windows NT 4.0 and TEMP Folders
To set up a system variable on a Windows NT 4.0 computer, follow these steps:
 * 1) Right-click My Computer, and then click Properties on the shortcut menu.
 * 2) Click the Environment tab.
 * 3) Inspect the list to see whether the %TEMP% variable is present and correctly identified. If not, skip to step 4.
 * 4) Select an entry in the System Variables List box, and then click New.
 * 5) 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 .)
 * 6) Click OK to save the new variable.
 * 7) Reboot your computer to apply the change.

<div class="references_section">