<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=691074921-29072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Lonnie
Johnson<BR><B>Sent:</B> Tuesday, July 29, 2003 5:22 PM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> Re: [AccessD]
Count the times a table is opened<BR><BR></FONT></DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>So, back to my question, is there a method of tracking how many times a
user invokes an object from the database window. </DIV>
<DIV> </DIV>
<DIV>I assume the answer may be no since I can't seem to get an
answer.<BR><BR><B><I>William Hindman <wdhindman@bellsouth.net></I></B>
wrote:</DIV>
<DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT face=Arial size=2>...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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>...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. :)))</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=prodevmg@yahoo.com href="mailto:prodevmg@yahoo.com">Lonnie
Johnson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 29, 2003 4:26
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Count the
times a table is opened</DIV>
<DIV><BR></DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV><BR><BR><B><I>"Wortz, Charles" <<A
href="mailto:CWortz@tea.state.tx.us">CWortz@tea.state.tx.us</A>></I></B>
wrote:</DIV>
<DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2>Lonnie,</FONT></SPAN></DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=241124019-29072003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=241124019-29072003></SPAN><SPAN lang=en-us><B><FONT
color=#0000ff>Charles Wortz</FONT></B></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>Software Development Division</FONT></SPAN> <BR><SPAN
lang=en-us><FONT color=#0000ff>Texas Education Agency</FONT></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Lonnie
Johnson [mailto:prodevmg@yahoo.com] <BR><B>Sent:</B> Tuesday 2003 Jul 29
14:32<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> [AccessD] Count the times a table is
opened<BR><BR></FONT></DIV>
<DIV>Is there a way to record when a table (or any object) is opened
from the database window?</DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie
Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional
Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR> </P></DIV></DIV></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie
Johnson<BR></STRONG><STRONG>ProDev</STRONG>, Professional
Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design software
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></DIV><BR><BR>
<DIV>
<DIV>
<P align=center><STRONG>Lonnie Johnson<BR></STRONG><STRONG>ProDev</STRONG>,
Professional Development of MS Access Databases<BR>Visit me at ==> <A
href="http://www.prodev.us/">http://www.prodev.us</A></P>
<P><BR><A
href="http://www.galaxymall.com/software/PRODEV"><BR></A><BR> </P></DIV></DIV>
<P>
<HR SIZE=1>
Do you Yahoo!?<BR><A
href="http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com">Yahoo!
SiteBuilder</A> - Free, easy-to-use web site design
software</BLOCKQUOTE></BODY></HTML>