[AccessD] Who is locking the record

Someone on this list (Drew maybe?) said that the information is stored 
in WINDOWS lock system.  IOW to Windows this is really just a file.  JET 
uses the windows lock system to create locks and uses some part of that 
lock mechanism to say what pieces of the MDB file is being locked.  It 
is a "place a lock from byte x to byte Y of file z".

It is not clear that even Jet knows WHO is locking something, only that 
something is being locked.

OTOH this entire subject is not clear to me.  I have never seen it 
written down that this is the way it actually happens, it was just some 
list member saying so.

I did find this which appears to explain this process:

http://www.wotsit.org/download.asp?f=jetlock&sc=264608112

John W. Colby
www.ColbyConsulting.com


Jennifer Gross wrote:
> You are correct.  I can see all the users that are logged in, as well as
> their computer name, but I am not seeing any other information.  Access is
> storing it somewhere, wish they would let me at it.
> 
> Jennifer 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris
> Sent: Tuesday, May 20, 2008 11:52 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Who is locking the record
> 
> 
>  You could look in the ldb file, of some versions of Access,  using notepad,
> and see who is logged into the mdb.
> 
>  But I think it won't tell you has what record is claimed by whom.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jennifer Gross
> Sent: Tuesday, May 20, 2008 12:24 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Who is locking the record?
> 
> 
> 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
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
> Sent: Friday, May 16, 2008 1:13 PM
> To: AccessD List
> Subject: [AccessD] Who is locking the record?
> 
> Hi All,
> 
> In a multi-user split database using Access security, using the statement
> 
> Currentdb.Execute SQLUpdateQueryName, dbFailOnError
> 
> When it generates the error 3218 that a record is locked, how can I find out
> which user is locking that record?
> 
> Is there a better way to do this?  What I want to do is know that the
> operation failed and let the user know which other user they need to go to
> and ask them to close a screen, or whatever.
> 
> Thanks in advance,
> 
> Jennifer
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>