<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2>Lonnie,</FONT></SPAN></DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff size=2>
Just to clarify a bit on some of the things that have been
said:</FONT></SPAN></DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff size=2>
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.</FONT></SPAN></DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff size=2>
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.</FONT></SPAN></DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff size=2>
No locking/object access info is stored in the system
tables.</FONT></SPAN></DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=540263214-08082003><FONT face=Arial color=#0000ff
size=2>HTH,</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Lonnie
Johnson<BR><B>Sent:</B> Thursday, August 07, 2003 12:49 PM<BR><B>To:</B>
Access Developers discussion and problem solving<BR><B>Subject:</B> [AccessD]
Who is linked to my back end?<BR><BR></FONT></DIV>
<DIV>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?</DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>,
Professional Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design
software</BLOCKQUOTE></BODY></HTML>