Count number of times a Db has been opened.

[cindy007]

Hi,
Is there any way that one can count the number of times that their database has been opened, or number of times a button has been clicked? Sort of like a 'Hit Counter'.

Cindy

 

[pdx_man]

Is this DB shared or are there multiple copies on users computers?

Basically, you could have a table that you have one value in that you increment. Have the DB open a form that is not visible that will do this. Then have that form open your main form.

Or, create an update query:
UPDATE Table4 SET Table4.Field1 = [Field1]+1;

that runs from your Autoexec Macro that will run the query. Be sure to use the SetWarnings to turn messages both off and on.

There are many ways of doing this as more ideas are sure to be added to mine.

 

[cindy007]

Count number of times a Db is accessed.

Thanx for the help, I made an Autoexec macro and created an update query as you said, and it works like magic...

Thanks
Cindy