[AccessD] Who is linked to my back end?

Don Elliker delliker at hotmail.com
Thu Aug 7 12:33:39 CDT 2003


Not for nothing, but, SOMEthing is writing that LDB and seems to know a bit 
about the access to the Db. I wonder if any fields in the system tables are 
storing access information? I must say, I have never really looked to see 
how the LDB file gets created, etc. -but it gives one pause,no?
_d


"Things are only free to the extent that you don't pay for them".-Don 
Elliker





>From: Lonnie Johnson <prodevmg at yahoo.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Who is linked to my back end?
>Date: Thu, 7 Aug 2003 10:25:16 -0700 (PDT)
>
>Thank you John. We don't always get the answer we want, but at least we 
>know what direction to go from there. I appreciate you taking the time to 
>respond.
>
>
>
>John Colby <jcolby at colbyconsulting.com> wrote:
>Boy, now there is a million dollar question.  My best guess would be no.  
>If you think about it, accesses to the table may not even be done via 
>"links" which implies an Access FE.  The access to the tables may come from 
>VB, a web page etc.  All of these could use DAO or ADO.
>
>I think the best that you can do is look at the LDB (lock file) and see who 
>is CURRENTLY using the db.  This method is far from reliable however since 
>there are cases where "user data" is not cleaned out of this file when the 
>user shuts down abnormally etc.
>
>John W. Colby
>www.colbyconsulting.com
>-----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_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>
>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
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail



More information about the AccessD mailing list