Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can you determine who has a table locked

Status
Not open for further replies.
Pack10

Pack10

Programmer
Feb 3, 2010
495
US
Is there a way to determine who has a table locked.
I am trapping error 3009, but I would like to display to the users the
table is locked by.....John or Bob.
 
Sort by date Sort by votes
How about checking the ldb or laccdb lock file? That may not tell you which user has a specific table locked, but at least will let you know who is in the database. Just open the lock file with a text editor and it will contain the usernames of people currently in the database.
 
Upvote 0 Downvote
Thanks for the response but there are 5 users who are always in the app during the day.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
267
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
422
lameid
lameid
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
299
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
417
dhookom
dhookom
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
468
serino
serino

Part and Inventory Search

Sponsor

Back
Top