Gaining exclusive access to a database

[Guest]

I have an access database with a macro designed to run maketable queries each
morning based on data found in linked tables. The problem I am running into
is that the macro fails if anyone other than me has the database open at the
time. In other words I need to have the database in exclusive mode.

Is there a way to place the database in exclusive mode on my machine if
another user already has it open?

basically I would like to be able to kick people out during the scheduled
macro run if they have not closed out on thier own.

Thanks!

 

[Roger Carlson]

No, you can't open it exclusively if someone else has it open. However, you
CAN create a process to kick all users off the database. On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"LogUsersOff.mdb" which illustrates how to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L