[AccessD] Who is linked to my back end?

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.
 
You would have to start the other way and look at each front end to see
what connections it held, I'm afraid. 
 
Charlotte Foust

	-----Original Message-----
	From: Lonnie Johnson [mailto:prodevmg at yahoo.com] 
	Sent: Thursday, August 07, 2003 8:49 AM
	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 <http://www.prodev.us/> 

	
	
	<http://www.galaxymall.com/software/PRODEV> 
	 

	
  _____  

	Do you Yahoo!?
	Yahoo! SiteBuilder
<http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>  -
Free, easy-to-use web site design software

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030807/c45d33cd/attachment-0001.html>