Microsoft KB Archive/316675

= An unhandled exception may occur when you try to connect to an Access database from an ASP.NET worker process =

Article ID: 316675

Article Last Modified on 5/13/2007

-

APPLIES TO


 * Microsoft ADO.NET 2.0
 * Microsoft ADO.NET 1.0
 * Microsoft ASP.NET 1.0
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition
 * Microsoft Office FrontPage 2003

-



This article was previously published under Q316675



This article refers to the following Microsoft .NET Framework Class Library namespace:
 * System.Data.OleDb



SYMPTOMS
An unhandled exception may occur under the following circumstances:
 * An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account.

-and-


 * You do not enable impersonation on that application.

-and-


 * You try to connect to or write to an Access database.

Under these circumstances, you may receive one of the following exceptions:

The Microsoft Jet database engine cannot open the file 'C:\Nwind.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Operation must use an updateable query.



CAUSE
Because of security concerns, the ASP.NET worker process runs under the default ASPNET account. If you do not enable impersonation for an application, all of the threads that run the requests for that application run under the process account.

This problem occurs because the ASPNET account does not have sufficient permissions to connect to or write to an Access database.



RESOLUTION
To work around this problem, use one of the following methods:
 * Configure the ASP.NET worker process to run under the SYSTEM account in the  section of the Machine.config file.
 * For security reasons, Microsoft recommends that you enable impersonation on your ASP.NET application. This method works if the impersonated user has necessary permissions to the computer and the database that you are accessing.
 * Grant read and write permissions for the &quot;Everyone&quot; group on the database and the database folder. This method is not safe; therefore, Microsoft does not recommend this method.



STATUS
This behavior is by design.



MORE INFORMATION
When you need unlimited users, full-time support, and ACID transactions, Microsoft strongly recommends that you use Microsoft SQL Server with Microsoft Internet Information Services (IIS). Although Microsoft Active Server Pages (ASP) works with any OLE DB-compliant or ODBC-compliant database, IIS has been extensively tested. IIS is designed to work with Microsoft SQL Server on high transaction traffic and with unlimited users, which can occur in an Internet scenario.

Note &quot;ACID&quot; is an acronym for the four properties of transaction-processing systems: Atomicity, Consistency, Isolation, Durability.

ASP supports the use of the Microsoft Jet database engine as a valid data source. However, Microsoft ODBC Driver for Access and Microsoft OLE DB Provider for Jet are not intended for use with high-stress, high-concurrency, full-time server applications (such as Web applications, commerce applications, transactional applications, messaging servers, and so on).

Steps to reproduce the behavior
 Create a new ASP.NET Web Application project in Microsoft Visual C# .NET.  Add the following code to the &quot;Declaration&quot; section of your Web Form, which appears at the top of the Code window: using System.Data.OleDb;                   Add the following code to the Page_Load event: String myConn =&quot;Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\\Nwind.mdb;&quot;; String myQuery = &quot;Insert into Customers(CustomerID,CompanyName) Values ('aaaaa', 'aaaaa')&quot;;

OleDbConnection cn = new OleDbConnection(myConn); cn.Open; OleDbCommand cmd = new OleDbCommand(myQuery, cn); cmd.ExecuteNonQuery; cn.close;  Modify the connection string as appropriate for your environment.</li> Compile the project.</li> View WebForm1.aspx in your browser. Notice that you receive one of the above-mentioned exceptions.</li></ol>

<div class="references_section">