Random Errors When Performing IDC or ASP Queries to an Access Database

WORKAROUND

To work around this problem, create System Environment variables for both TMP and TEMP with the value %SystemDrive%\TEMP, as shown below:

1. In Control Panel System, click the Environment tab.
2. Select a variable in the System Variables box.
3. In the Variable box, select the current variable name and type TMP (or TEMP).
4. Click Set.
5. In the Value box, type:

   %SystemDrive%\TEMP

6. Click Set.
7. Close Control Panel and restart the computer.

NOTE: If you are not allowing anonymous authentication, and instead using Basic or NT Challenge response, you must give the write permission for the Winnt folder to individual users or groups.