[AccessD] Count the times a table is opened

Not that I know of.

A possible work around off the top of my head (if no one else can tell you
how to do it directly):
In the ADH there's a discussion of presenting a tabbed form that looks
exactly like the access database object container.

You could recreate that form,
hide the DB window (set the bypass key to false so they couldn't use that)
set the double click event of the table view list to record: the item being
opened, the count of the times opened, and then open the actual table in
datasheet view.

HTH
John B.
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lonnie Johnson
  Sent: Tuesday, July 29, 2003 4: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/10b6ac33/attachment-0001.html>