[AccessD] Who is linked to my back end?

MessageAnd even the user roster doesn't address specifics like what that
user is doing in the db, only that they are in the db.
John W. Colby
www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust
  Sent: Thursday, August 07, 2003 2:28 PM
  To: Access Developers discussion and problem solving
  Subject: RE: [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








----------------------------------------------------------------------------
    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/20030807/1969d7d3/attachment-0001.html>