[AccessD] Count the times a table is opened

Lonnie Johnson prodevmg at yahoo.com
Tue Jul 29 16:21:47 CDT 2003


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/055b9402/attachment-0001.html>


More information about the AccessD mailing list