[AccessD] Who is locking the record?

Jennifer Gross jengross at gte.net
Tue May 20 14:24:13 CDT 2008


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





More information about the AccessD mailing list