I need to make sure that no others users can make changes (i.e. INSERTS, UPDATES & DELETES) in a centralized Access 2007 database while a certain VBA macro is running, and then I would release the lock.
How can I do that in VBA, DAO or ADO?
N.B.: The lock, however, would not prevent others users from executing VBA code that does simple SELECT queries.