jcolby at colbyconsulting.com
jcolby at colbyconsulting.com
Tue Jul 29 16:50:02 CDT 2003
AFAIK, there is no way to tell if a table or query is opened directly.
Neither of these objects has any events to run code in.
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: Tuesday, July 29, 2003 5:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Count the times a table is opened
Believe me, I know all this. You are preaching to the choir. This is a
small company that has their own way of doing things. I've had this argument
for over a year now and haven't won. If they pay me to do it, I do it.
So, back to my question, is there a method of tracking how many times a
user invokes an object from the database window.
I assume the answer may be no since I can't seem to get an answer.
William Hindman <wdhindman at bellsouth.net> wrote:
...so build him a continuous records form that looks like the table's
database window but isn't ...with him in the real table your rectum is
exposed big-time, not his ...and with the form approach, you not only can
limit the damage he can do but the access count becomes much easier to
provide.
William Hindman
...It's a proven fact that if you smoke a pack of cigarettes a day for
90 years, you'll live to a ripe old age. :)))
----- Original Message -----
From: Lonnie Johnson
To: Access Developers discussion and problem solving
Sent: Tuesday, July 29, 2003 4:26 PM
Subject: RE: [AccessD] Count the times a table is opened
I am 1000 percent in agreement with you. However, I have a CFO who
literally signs the checks and demands direct access to a certain table for
him and a couple of others, but wants to know how many times they get into
it.
"Wortz, Charles" <CWortz at tea.state.tx.us> wrote:
Lonnie,
IMHO the database window should only be available in Design mode.
Letting the users get at the database window is a serious mistake that you
will regret ever making.
Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us
-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Tuesday 2003 Jul 29 14:32
To: Access Developers discussion and problem solving
Subject: [AccessD] Count the times a table is opened
Is there a way to record when a table (or any object) is opened from
the database window?
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us
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
_______________________________________________
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/20030729/e3278ac2/attachment-0001.html>