<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>