Lonnie Johnson
prodevmg at yahoo.com
Thu Aug 7 13:22:21 CDT 2003
You raise some great issues here John. I thank you again for your thoughts. However, I was reaching a bit in a different. I was wanting to know of ANYONE and EVERYONE that had a link to a particular table in my back end no matter if they were using it or not. I have an officer of the company wanting to know who could be linked to a particular table. It would have likely been via the linked table manager/wizard. Thanks again. John Colby <jcolby at colbyconsulting.com> wrote: AFAIK, JET and only JET "knows" the internals of the Access db. It creates the lock db and it handles requests for data from an MDB from requesters such as DAO and ADO. It does indeed give one pause. This is a sore point with the use of an MDB. OTOH, can you "ask" SQL Server who is accessing a given table at the moment? I don't have the answer to that. Now that someone has asked, it seems a logical thing to do, or at the very least ask who has accessed a given table (historical). The problem is that there are so many paths in to data. A document in word could do a mail merge. That document could be opened from a VB front end remotely. "who" is asking for the data? The document? The user of the machine that used automation to open the document? And if the request comes from the web... how in the world do you determine who asked for the data. At best you would get an application as the requester. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Don Elliker Sent: Thursday, August 07, 2003 1:34 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Who is linked to my back end? 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 >Reply-To: Access Developers discussion and problem >solving >To: Access Developers discussion and problem >solving >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 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030807/0ac7509f/attachment-0001.html>