<DIV>You raise some great issues here John. I thank you again for your thoughts. <IMG src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"></DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thanks again.<BR><BR><B><I>John Colby <jcolby@colbyconsulting.com></I></B> wrote:</DIV>
<DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">AFAIK, JET and only JET "knows" the internals of the Access db. It creates<BR>the lock db and it handles requests for data from an MDB from requesters<BR>such as DAO and ADO.<BR><BR>It does indeed give one pause. This is a sore point with the use of an MDB.<BR>OTOH, can you "ask" SQL Server who is accessing a given table at the moment?<BR>I don't have the answer to that. Now that someone has asked, it seems a<BR>logical thing to do, or at the very least ask who has accessed a given table<BR>(historical). The problem is that there are so many paths in to data. A<BR>document in word could do a mail merge. That document could be opened from<BR>a VB front end remotely. "who" is asking for the data? The document? The<BR>user of the machine that used automation to open the document? And if the<BR>request comes from the web... how in the world do you determine who asked<BR>for the data. At
best you would get an application as the requester.<BR><BR>John W. Colby<BR>www.colbyconsulting.com<BR><BR>-----Original Message-----<BR>From: accessd-bounces@databaseadvisors.com<BR>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Don Elliker<BR>Sent: Thursday, August 07, 2003 1:34 PM<BR>To: accessd@databaseadvisors.com<BR>Subject: RE: [AccessD] Who is linked to my back end?<BR><BR><BR>Not for nothing, but, SOMEthing is writing that LDB and seems to know a bit<BR>about the access to the Db. I wonder if any fields in the system tables are<BR>storing access information? I must say, I have never really looked to see<BR>how the LDB file gets created, etc. -but it gives one pause,no?<BR>_d<BR><BR><BR>"Things are only free to the extent that you don't pay for them".-Don<BR>Elliker<BR><BR><BR><BR><BR><BR>>From: Lonnie Johnson <PRODEVMG@YAHOO.COM><BR>>Reply-To: Access Developers discussion and problem<BR>>solving<ACCESSD@DATABASEADVISORS.COM><BR>>To: Access Developers
discussion and problem<BR>>solving<ACCESSD@DATABASEADVISORS.COM><BR>>Subject: RE: [AccessD] Who is linked to my back end?<BR>>Date: Thu, 7 Aug 2003 10:25:16 -0700 (PDT)<BR>><BR>>Thank you John. We don't always get the answer we want, but at least we<BR>>know what direction to go from there. I appreciate you taking the time to<BR>>respond.<BR>><BR>><BR>><BR>>John Colby <JCOLBY@COLBYCONSULTING.COM>wrote:<BR>>Boy, now there is a million dollar question. My best guess would be no.<BR>>If you think about it, accesses to the table may not even be done via<BR>>"links" which implies an Access FE. The access to the tables may come from<BR>>VB, a web page etc. All of these could use DAO or ADO.<BR>><BR>>I think the best that you can do is look at the LDB (lock file) and see who<BR>>is CURRENTLY using the db. This method is far from reliable however since<BR>>there are cases where "user data" is not cleaned out of this file when
the<BR>>user shuts down abnormally etc.<BR>><BR>>John W. Colby<BR>>www.colbyconsulting.com<BR>>-----Original Message-----<BR>>From: accessd-bounces@databaseadvisors.com<BR>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Lonnie Johnson<BR>>Sent: Thursday, August 07, 2003 12:49 PM<BR>>To: Access Developers discussion and problem solving<BR>>Subject: [AccessD] Who is linked to my back end?<BR>><BR>><BR>>In a case of a "back end" holding data and various "front end interfaces",<BR>>is there a way to determine who or what is linked to the back end? Any<BR>>script I can run on the back end to determine what is linked to it and what<BR>>tables is that other database looking at?<BR>><BR>><BR>><BR>>Lonnie Johnson<BR>>ProDev, Professional Development of MS Access Databases<BR>>Visit me at ==>
http://www.prodev.us<BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>>---------------------------------<BR>>Do you Yahoo!?<BR>>Yahoo! SiteBuilder - Free, easy-to-use web site design<BR>>software_______________________________________________<BR>>AccessD mailing list<BR>>AccessD@databaseadvisors.com<BR>>http://databaseadvisors.com/mailman/listinfo/accessd<BR>>Website: http://www.databaseadvisors.com<BR>><BR>><BR>><BR>><BR>>Lonnie Johnson<BR>>ProDev, Professional Development of MS Access Databases<BR>>Visit me at ==> http://www.prodev.us<BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>>---------------------------------<BR>>Do you Yahoo!?<BR>>Yahoo! SiteBuilder - Free, easy-to-use web site design software<BR>>_______________________________________________<BR>>AccessD mailing
list<BR>>AccessD@databaseadvisors.com<BR>>http://databaseadvisors.com/mailman/listinfo/accessd<BR>>Website: http://www.databaseadvisors.com<BR><BR>_________________________________________________________________<BR>STOP MORE SPAM with the new MSN 8 and get 2 months FREE*<BR>http://join.msn.com/?page=features/junkmail<BR><BR>_______________________________________________<BR>AccessD mailing list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website: http://www.databaseadvisors.com<BR><BR><BR><BR>_______________________________________________<BR>AccessD mailing list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website: http://www.databaseadvisors.com</BLOCKQUOTE></DIV><BR><BR><DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional Development of MS Access Databases<BR>Visit me at ==> <A href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo! SiteBuilder</a> - Free, easy-to-use web site design software