CodeKicks.com
Focus on Microsoft Technologies - Tutorials, Articles, Code Samples.

Wednesday, August 30, 2006

System.Data.OleDb.OleDbException

System.Data.OleDb.OleDbException: The Microsoft Jet
database engine cannot open the mdb file. It is already
opened exclusively by another user, or you need permission to view its data.

Solution

When you attempt to connect to an Access mdb from asp.net, you are not
connecting with *your* permissions on the file system, but with those
of the ASP.NET Machine Account (ASPNET). This is a restricted account
and is determined by the <processModel> section in the Machine.config
file. It affects all ASP.NET applications running on the server by
sandboxing them so that they do not have administrative file access on
the host box. Grant the necessary ACLs to ASPNET on the folders
containing the mdb and mdw files (read, write, delete so the .ldb
files get cleaned up).

Links :http://www.mcse.ms/archive101-2004-12-1244311.html

Post a Comment