[AccessD] Count the times a table is opened

...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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030729/b608f02f/attachment-0001.html>