locked Table

[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

 

[Tom van Stiphout]

On Tue, 8 Apr 2008 08:13:00 -0700, Raf <[email protected]>
wrote:

Not sure what you mean by "rebuild". If you mean change the table
design, then that's really not something you should do on a production
database while users are in it. Rather you would do this to a beta
database, and after tested OK, re-apply the changes to the production
db after hours.

-Tom.

 

[Raf]

What I meant is that I wrote a code to delete table in the BE and recreate it
with “make table query" I did this because is faster to access the BE tables
than going through queries involving linked tables to our accounting system.