[AccessD] Who is locking the record

Jack and Pat drawbridgej at sympatico.ca
Tue May 20 14:24:24 CDT 2008


Jennifer,
I found this kb article that relates to - but does not solve- your issue.
It may be useful???

http://support.microsoft.com/kb/198755/EN-US/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
Sent: Tuesday, May 20, 2008 3:59 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Who is locking the record

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


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



More information about the AccessD mailing list