VBA to tell if "Table Open".

[Uncle Gizmo]

I've got some VBA code which deletes a table:

But it won't delete the table when the table is being used.

I need to test first to see if a table is being used, I would assume the correct term would be "table open".

Does anyone know how to do this?

 

[jdraw]

see post #4 at http://www.utteraccess.com/forum/check-table-open-t1837408.html

 

[Steve R.]

Based on a google search, the following may work.

See Post #4 by CyberCow. "How can I check to see if table is Open"

 

[Steve R.]

see post #4 at http://www.utteraccess.com/forum/check-table-open-t1837408.html

jdraw: So what are the chances that two people find the same post at virtually the same time?

 

[Uncle Gizmo]

Thank you both... Haven't been to Utter Access for a long long time...

Might have to start posting there again!