<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=102495620-07082003><FONT face=Arial color=#0000ff size=2>And
even the user roster doesn't address specifics like what that user is doing in
the db, only that they are in the db.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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>Charlotte
Foust<BR><B>Sent:</B> Thursday, August 07, 2003 2:28 PM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> RE: [AccessD] Who
is linked to my back end?<BR><BR></FONT></DIV>
<DIV><SPAN class=561302418-07082003><FONT face="Comic Sans MS" color=#0000ff
size=2>You can determine open connections using ADO to retrieve the User
Roster, but there's no way I know of to find discover front ends that aren't
open. For that matter, the roster only tells you the user login and
workstation holding the connection open, not the database.</FONT></SPAN></DIV>
<DIV><SPAN class=561302418-07082003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=561302418-07082003><FONT face="Comic Sans MS" color=#0000ff
size=2>You would have to start the other way and look at each front end to see
what connections it held, I'm afraid. </FONT></SPAN></DIV>
<DIV><SPAN class=561302418-07082003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=561302418-07082003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Lonnie Johnson
[mailto:prodevmg@yahoo.com] <BR><B>Sent:</B> Thursday, August 07, 2003 8:49
AM<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></BLOCKQUOTE></BODY></HTML>