Msg Box saying that a table is open

A

AccessFitz

I've searched the board for this ? and can't seem to find what I'm looking for.

I have a command button. Within this command button, I have several queries
that run. What I would like to do, is button a msgbox command within the
button restricting a user to click on the button if another user is in a
table. I want a message box to appear saying "Another User is currently is
another table." I know how to build the message box, but I'm not sure how to
write the VB code saying that a table is open by another user?

Does anyone know?

Thanks
AccessFitz
 
S

salut

Why do you need that?
If another user is changing something in the table, the table will be locked
for his usage, you would not be able to change it anyway.
 
A

AccessFitz

Salut,

When you have a make table in your command button. An Error will populate
saying
the table is already opened by an exclusive user. I want a build some code
into the button to know if someone is currently in that table. If the table
is opened.
 
Top