<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Presumably if everyone is accessing the BE thru
fixed front ends, then all the front ends can be designed to log all accesses,
as they go? (Appending details to log tables in the BE?)
Presumably most accesses are thru the front ends??? Yes this isn't
watertight, but its a damned good start.</FONT></DIV>
<DIV>Kind regards,<BR>David
Hingston<BR>_________________________________________________________________________<BR><BR>Engines2Go
- Now THAT's a Search Engine!<BR>Automated major search engine manager<BR>Makes
searching quicker and easier - Have you tried it? <BR><A
href="http://www.engines2go.com/">http://www.engines2go.com/</A> <BR><A
href="http://www.cheqsoft.com/">http://www.cheqsoft.com/</A> The home of
Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=prodevmg@yahoo.com href="mailto:prodevmg@yahoo.com">Lonnie
Johnson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, August 08, 2003 7:10
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Who is linked to
my back end?</DIV>
<DIV><BR></DIV>
<DIV>Hey Don, I shared this with my Supervisor and we had the greatest laugh.
You are right on the nail<BR><BR><B><I>Don Elliker <<A
href="mailto:delliker@hotmail.com">delliker@hotmail.com</A>></I></B> wrote:
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">It
would probably be managed better in the other direction. Either secure
<BR>the application/BE files or folders in which they are kept. Then you (or
the <BR>Big Chief) need not wonder (too much) who's accessing tables - that
really <BR>is a Big Chief question....boy they can sure ask 'em - "Hey, I
want to know <BR>everybody who has EVER parked around my parking space- I
got a ding in my <BR>Beemer!!"<BR>_d<BR><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 11:22:21 -0700
(PDT)<BR>><BR>>You raise some great issues here John. I thank you
again for your thoughts.<BR>><BR>>However, I was reaching a bit in a
different. I was wanting to know of <BR>>ANYONE and EVERYONE that had a
link to a particular table in my back end no <BR>>matter if they were
using it or not.<BR>><BR>>I have an officer of the company wanting to
know who could be linked to a <BR>>particular table. It would have likely
been via the linked table <BR>>manager/wizard.<BR>><BR>>Thanks
again.<BR>><BR>>John Colby
<JCOLBY@COLBYCONSULTING.COM>wrote:<BR>>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 <BR>>moment?<BR>>I don't have the ans! wer 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 <BR>>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<BR>><BR>> >Reply-To: Access Developers
discussion and problem<BR>> >solving<BR>> >To: Access Developers
discussion and problem<BR>> >solving<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
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 <BR>>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 <BR>>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 <BR>>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 Beha! lf 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
<BR>>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 <BR>>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<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>&g!
t;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</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
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>