Find which user has record locked.

[ThomasAJ]

I have pessimistic locking/edited record.

How do I find out which user has locked a record in a form?

 

[Larry Daugherty]

I believe that you can find something useful at www.msdn.microsoft.com
Search for LDB View. If you have no joy there then do a search on
those same two terms (put them in quotes) at www.groups.google.com I
know there has been a post in these groups sometime in the last day or
so.

HTH

 

[ThomasAJ]

There is a utility call 'LDB View' but is only good for non-Jet 4.0 DBs
(prior Access 2000). Anyway that would only allow viewing.

I cannot find anything that can programmatically determine who has record
locked and show that to the 'locked out' person. The 'locked out' person
could yell out to the 'locker', "hey you...". I think you know what I mean.

--
Regards
Tom

I believe that you can find something useful at www.msdn.microsoft.com
Search for LDB View. If you have no joy there then do a search on
those same two terms (put them in quotes) at www.groups.google.com I
know there has been a post in these groups sometime in the last day or
so.

HTH

 

[Larry Daugherty]

Now I understand what you mean. Good luck in your search.

--
-Larry-
--

There is a utility call 'LDB View' but is only good for non-Jet 4.0 DBs
(prior Access 2000). Anyway that would only allow viewing.

I cannot find anything that can programmatically determine who has record
locked and show that to the 'locked out' person. The 'locked out' person
could yell out to the 'locker', "hey you...". I think you know what I mean.

 

[lewie]

Garry Robinson has a good book out about security which has alot of
info in it about creating tables to enter who is logged in ect. you may
google him for info. Whenever we get locked out of a db it lists the
users machine who has it locked out. We have a user group list that has
user phone number and machine number in a spreadsheet. Just look up
number and call.
Lewie