How to detect if Access is opened exclusively

Hello,

I've just adjusted my Access database to use local tables to do data entry then send that data to the shared data tables (split DB - GUI/Data mdb's) and as a result will need to ensure that users have got a local PC copy of the GUI database file. So testing for the GUI file being opened exclusively via cmd /excl command line would be good (or via the Access DB options ->Advanced -> exclusive ).

I can't seem to find the VBA method for testing if the CurrentDB is opened in Exclusive mode. Does anyone know the answer




Answer this question

How to detect if Access is opened exclusively

  • How to detect if Access is opened exclusively