locked Tables

[Raf]

I have a database split in BE & FE. when any user open the FE they lock the
tables in the BE. This does not allow me to run code to rebuild some tables.
My question is:
1- Is there a way to not allow any user to lock the BE tables used in the FE
forms?
2- If not 1 then can you show me the code to tell me who has the BE Locked?

Thank you

 

[Ken Snell \(MVP\)]

Is the backend set to allow shared use, not exclusive use?

When set to shared use, the only tables that would be locked are those
actually being used in the front end at that time (because a form, report,
or query is open, and the form, report, or query is bound to that table).

See #24 at this website for some code that will give you some information
about who is using the backend:
http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html