Who has locked what?

[Pasvorto]

From time to time, my users get a message that a record is locked by naother user. I can see who is accessing the db (ACESS 2000), but I can't find out who has the record locked. Is there a way (in vb6) to determine who has a record/table locked?

[j_jewell]

If you open up the .ldb file that is created (with any text editor -- e.g. notepad), you will see the UserIDs of anyone who is currently in the database. Beyond that, I'm not sure. But, if you only have one or two other people in the .ldb, it wouldn't be hard to determine the culprit.

[Briantcva]

That *can* work (and often does) but it's not guaranteed. Check out this thread.

[j_jewell]

Good catch. Be sure to note the microsoft support article referenced on that page.

[Pasvorto]

That is all godd and fine. However, I can, with the Windows resource kit, tell who is logged into the db. What I need to know is who is accessing what table at any given time. I have users that will open a screen which updates the db and leave the PC sitting there, thereby locking out anyone else. I haved tried to ease the problem by judicious use of = nothing code to release the record set. I try to not open the recordset until they have pushed the 'update' button.

I am leaning toward the idea that it can't be done.

[Briantcva]

The front-end needs to be redesigned such that this can't happen. B/c users will always f***-up a perfectly good idea. Think disconnected recordsets and the like.

[j_jewell]

Not my users. I work in user eutopia. All of my users must pass a minimum requirement of knowing their head from their a$$ before their resume will even be considered. They are all "expert" Access users as well -- just ask them.

Oh...I'm sorry, I just woke up.