General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Identifying locked tables
I am having a multi-user issue that I cannot identify. The app has been in use for about a year with no problems. Modifications made over the past three months have all been run as single user -- now we are having "Waiting for Lock" issues but can not identify which file it is waiting to lock.
The status bar shows one of the many open files, but it is not the problem table. I have an ON KEY LABEL F12 DISPLAY STATUS in place so I can monitor what is locked, but once the app goes to "WAITING FOR LOCK" I'm stuck. Is there any way to monitor WHO has WHAT locked in a multiuser environment?
Thanks,
Bly Beach
Discovery Unlimited
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only