How to obtain a lock on MDB(Access) Database file?

Question

Using - Visual Studio 2005, C# Forms App, MS Access Database , Microsoft OleDB Jet Driver

Problem -

My Application(C#) uses an mdb file as a database. I want to obtain a lock on the entire file so that a user is not able to open/edit the mdb file using MS Access while the application is running.

When one opens a mdb file with MS Access a hidden file is created of type "Access.LockFile.9" with the same name as that of the mdb file. MS Access implements lock in this way.

How can i ?

Any possible way?

Answer 1

Hi,

I suggest that you can create an account who is the only one that can edit/update the Access file, and in your case, that account is your application running account.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Nai-dong Jin,

Couldnt understand what you wrote.

---

Vibhor Agarwal