.NET Questions and Solutions

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.
Resolution
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.

Symptoms
When you build or run a client application (such as a Microsoft Visual C++ application) that runs anSQL statement on a Microsoft Jet data source, the client application may fail with anunhandled exception. You may receive an error message that is similar to thefollowing:

Unknown The error message may also contain the following error code:

0×80040e14 This problem may occur even if theclient application runs a valid SQL statement.
Resolution
This problem occurs because the Microsoft Jet database driver .dll file (Msjtes40.dll) is not correctly registered.