This error occurs because both the server that is running Microsoft Internet Information Services (IIS) and the computer where the Access database is located are not correctly configured for the ASP page to connect to the Access database.
To verify that the server and the computer where the Access database is located are configured correctly, follow these steps:
Verify the identity of the Internet Guest User account. To do this, follow these steps:
In IIS version 4.0, Right-click the Web site in the IIS Management Console, and then click Properties.
Click the Directory Security tab, and then click Edit in the Anonymous Access and Authentication box. The Authentication Methods dialog box appears.
Click the Edit button next to the account that is used for anonymous access. The Anonymous User Account dialog box appears. This dialog box displays the Windows NT user identity that IIS impersonates for the Web site.
Note that the setting is set specifically for each folder or virtual directory of the Web site, and for each specific ASP page in the Web site.
If a specific ASP page is experiencing problems, verify the properties for the ASP page and for the Web site.
If the Access database is located on a remote computer, you must take additional steps to configure the remote computer.
For additional information about how to connect to a remote Access database, click the following article number to view the article in the Microsoft Knowledge Base:
How to connect to a remote Access database from Active Server Pages
Set the permissions for the Access database. The database file must have at least read, write, execute, and change permissions for the Internet Guest User account. Additionally, configure the database folder to have at least read, write, execute, and change permissions.
The Microsoft Jet database engine uses temporary files while you work with Access databases. If the temporary folders are not defined in the system variables for the computer, the Microsoft Jet database engine creates and modifies the temporary files in the WINNT\System32 folder.
The temporary folder that the Access database uses requires that access be granted to the Internet Guest User account. However, it is not a good idea to give users this type of access. We recommend that you configure both the System TEMP environment variable and the TMP environment variable as follows:
Right-click My Computer, and then click Properties.
Click the Environment tab, and then click an existing variable in the System section of the tab. The variable name and the value appear in the text boxes of the System Properties dialog box.
To change the variable name, click the variable name, and then type TEMP in the Variable box.
In the Value box, modify the text to reflect the location of the temporary folder on the computer. Typically, the path is C:\TEMP.
Click SET. The variable is added to the System section.
Repeat steps 4a through 4e for the TMP environment variable.
Restart the computer.
Note You must restart your computer for these changes to take effect.
The temporary folder must have at least read, write, change, and delete permissions for the Internet Guest User account.