[AccessD] Count the times a table is opened

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>


More information about the AccessD mailing list