Tortise@Paradise
tortise at paradise.net.nz
Thu Aug 7 15:44:10 CDT 2003
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.
Kind regards,
David Hingston
_________________________________________________________________________
Engines2Go - Now THAT's a Search Engine!
Automated major search engine manager
Makes searching quicker and easier - Have you tried it?
http://www.engines2go.com/
http://www.cheqsoft.com/ The home of Clipboard Express, MP3 Detective, TimesOwn and Break Reminder.
----- Original Message -----
From: Lonnie Johnson
To: Access Developers discussion and problem solving
Sent: Friday, August 08, 2003 7:10 AM
Subject: RE: [AccessD] Who is linked to my back end?
Hey Don, I shared this with my Supervisor and we had the greatest laugh. You are right on the nail
Don Elliker <delliker at hotmail.com> wrote: It would probably be managed better in the other direction. Either secure
the application/BE files or folders in which they are kept. Then you (or the
Big Chief) need not wonder (too much) who's accessing tables - that really
is a Big Chief question....boy they can sure ask 'em - "Hey, I want to know
everybody who has EVER parked around my parking space- I got a ding in my
Beemer!!"
_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 11:22:21 -0700 (PDT)
>
>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 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 ans! wer 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 Beha! lf 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
>
>
>
>
>
>
>
>
>
>---------------------------------
&g! t;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
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030808/8c0dd40e/attachment-0001.html>