Jim Dettman
jimdettman at earthlink.net
Fri Aug 8 09:38:56 CDT 2003
Lonnie, Just to clarify a bit on some of the things that have been said: You can tell who is attached to the MDB by looking at the LDB file and the corresponding user locks. This is what the LDB viewer does. The LDB file supplies the machine and user name, the user lock tells you if the "slot" is active or not. Also by looking at the locks, you can tell who is using what table, but you need to go through all the locks for all users. No one I know of has bothered to do this. As with connections, there is a utility called DBLOCK that will tell you the table/page that is being locked based on a lock. The JET locking white paper has the outline of how to decipher locks. I don't believe it's been updated for JET 4.0 though. No locking/object access info is stored in the system tables. HTH, Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lonnie Johnson Sent: Thursday, August 07, 2003 12:49 PM To: Access Developers discussion and problem solving Subject: [AccessD] Who is linked to my back end? In a case of a "back end" holding data and various "front end interfaces", is there a way to determine who or what is linked to the back end? Any script I can run on the back end to determine what is linked to it and what tables is that other database looking at? Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ---------------------------------------------------------------------------- -- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030808/6568a39b/attachment-0001.html>