Gaining exclusive access to a database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Back
Top