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