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