Dear All,
I would like to create a marco which is able to check the table status, only table is free (not being used by another users) that updating process is allowed, otherwise a warming message will be pop-up.
Do anyone know how to check the table status?

Off the top I would suggest renaming the table, you will get an error if you try to rename it if a user [form, query] is accessing the table. Then quickly rename it back. There might be a more efficient way to test but I have never had the need. Did you search the forum [or goggle]?