Urgent: Open MS-Access database exclusively

May 12 2004 1:02 AM
Hi, Can anybody advice me on how can i open an ms-access database exclusively by my application, so that no other process will be able to access the database while my process is running. In my application, one process will connect to the server and upload all or some of the data into the server. There are other processes in the system which try to access the database irrespective of time. I do not want any process access the database while my first process i.e. "synchronization with server" is running. Is there any way to open the database (.mdb file) exclusively or any other ways to lock the mdb file for other processes which try to access the database. This is very urgent. Thanks and regards mrc

Answers (1)