OleDbException (exclusive access)

[Serge Lobko Lobanovsky]

I've got an ASP.NET application written in C# which uses an Access database. Sometimes, when several users try to access the application at the same time, a "file is opened exclusively by another user" exception is thrown. AFAIK, I need to synchronize access to the database. I've got a single place where all database access (like read a dataset, executenonquery) methods are. I tried using a ManualResetEvent to perform the task, but the problem is still there. Can anyone recommend an approach? Regards, Serge my blog on Easy Projects .NET and object-relational mapping

[Mike Dimmick]

To handle multiple users, the Jet database engine has to be able to create a .ldb file (i.e. if your database is called MyDatabase.mdb, it has to create MyDatabase.ldb). Check that the user account your ASP.NET process runs under can create files in the same directory as the .mdb. If Windows 2000 or XP, by default it's ASPNET, while on Windows Server 2003 it's NETWORK SERVICE. Stability. What an interesting concept. -- Chris Maunder

[Serge Lobko Lobanovsky]

Thank you very much, Mike! I thought it was a sync problem :omg: Regards, Serge my blog on Easy Projects .NET and object-relational mapping