Article ID: 316675 - View products that this article applies to.
This article was previously published under Q316675
This article refers to the following Microsoft .NET Framework Class Library namespace:
An unhandled exception may occur under the following circumstances:
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.
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.
To work around this problem, use one of the following methods:
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 "ACID" 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
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/306590/ )ASP.NET security overview
307626For more information about the <processModel> section, visit the following Microsoft Developer Network (MSDN) Web site:
(http://support.microsoft.com/kb/307626/ )ASP.NET configuration overview
Article ID: 316675 - Last Review: May 13, 2007 - Revision: 6.5
Contact us for more help
Connect with Answer Desk for expert help.