[AccessD] Count the times a table is opened

On 29 Jul 2003 at 13:26, Lonnie Johnson wrote:

> 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. 
> 

By direct access to the table, do you mean he insists on goin in 
through the database Window?  

How about just giving him  a button on a form somewhere to open the 
table?

Private Sub ShowCFOsTable_Click()
	Call LogCFOTableUsage(Username())
	Docmd.OpenTable "tblCFOsTable"
End Sub

-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.