[AccessD] Count the times a table is opened

Porter, Mark MPorter at acsalaska.com
Tue Jul 29 16:53:01 CDT 2003


It's more than a discussion, there is actually a form in the ADH97 source
code disk.
 
I've used it with runtime installations for users who were used to the DB
window.  They couldn't tell the difference for their purposes.
 
Mark

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net]
Sent: Tuesday, July 29, 2003 1:31 PM
To: Access Developers discussion and problem solving
Subject: RE: [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  <mailto:prodevmg at yahoo.com> Johnson 
To: Access Developers discussion  <mailto:accessd at databaseadvisors.com> 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 <mailto: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 <http://www.prodev.us/> 


 



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us <http://www.prodev.us/> 


 <http://www.galaxymall.com/software/PRODEV> 

 



   _____  

Do you Yahoo!?
Yahoo!  <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
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 <http://www.prodev.us/> 


 <http://www.galaxymall.com/software/PRODEV> 

 



   _____  

Do you Yahoo!?
Yahoo!  <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com>
SiteBuilder - Free, easy-to-use web site design software



This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030729/bef7e129/attachment-0001.html>


More information about the AccessD mailing list