Article ID: 825738 - View products that this article applies to.
When you connect to a Microsoft Access database from a Microsoft ASP.NET application, you receive the following error message:
System.Data.OleDb.OleDbException: Unspecified error
The ASP.NET Web application that has the impersonation element set to true in the Web.config file, and that has the authentication element set to Windows in the Web.config file, runs under the impersonated account. The code in the ASP.NET Web application connects to an Access database. When the connection is made, the Microsoft Jet OLE DB creates temporary files in the Temp folder in the following directory:
Document and Settings\ServerName\ASPNET\Local settingswhere ServerName is the name of your server.
If the impersonated user account does not have read/write permissions enabled in the Temp folder, you receive the error message that is mentioned in the "Symptoms" section.
To resolve this problem, enable read/write permissions for the impersonated user account in the Temp folder. To do this, follow these steps:
Steps to Reproduce the Behavior
For more information about ASP.NET impersonation, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/xh507fc5(vs.71).aspxFor more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/301195/ )How to configure security for files and folders on a network (domain) in Windows 2000
(http://support.microsoft.com/kb/316675/ )Cannot connect to Access database from ASP.NET
Article ID: 825738 - Last Review: May 18, 2007 - Revision: 3.5