[AccessD] Who is locking the record?

Dang.  You would think that since they can get at the information they would
expose it to us as well.  

My users find it handy when they are alerted who is locking the record.
You'd be amazed how many people are in the middle of editing a record and go
to lunch with the screen open, record locked.

Since I can't seem to figure out how to tell them who is locking the record
they have to walk around to everyone until they find out who is working on
the same record as they are.

Thanks for getting back to me John.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 20, 2008 10:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Who is locking the record?

To my knowledge it is not possible.

John W. Colby
www.ColbyConsulting.com


Jennifer Gross wrote:
> No takers on this?  Sometimes the Access message is generic and just 
> lets you know the record is locked.  Other times when a record is 
> locked Access will display their own message letting the user know who 
> is locking the record.  So it seems that information is available, 
> must be in the LDB file
> - does anyone know how to get at it? 
> 
> 3218 is a record locking error, perhaps 3188 as well.  I can trap the 
> error, but I don't know how to identify who is locking the record.
> 
> Jennifer

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com