B
Beverly76
I have a macro that updates tables which are used to run a report.
I want to make sure none of the tables I am about to update are locked by
other users at the time I run the macro.
I thought of checking the directory for an ldb file, but my being in the
database creates the file - so that wouldn't work.
I'm looking for possible code to put in the macro condition column to check
table by table for locks.
I want to make sure none of the tables I am about to update are locked by
other users at the time I run the macro.
I thought of checking the directory for an ldb file, but my being in the
database creates the file - so that wouldn't work.
I'm looking for possible code to put in the macro condition column to check
table by table for locks.