Conditional Macro, Check for Lock on Table or Query

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Embedded Excel into Word with Tables 0
Populate a table based on check box status 2
Creating a Chart on form from selected data in query. 0
Word macro that can call cells out of Excel for a find and replace 0
"Compile error in table level validation expression " after format 0

Top