Hi all,

I am needing to capture as much activity as I can within a database, and insert into a hidden table within the db.

you know how on all other microsoft apps you can run macros when the workbook/document etc is opened, is it possible that I can run a macro when the database is opened?

And the same on close? as in, i would like to set a variable when the user enters the database, and when they close, before close it writes the info to the table.

is this possible?

thanks

Patrick

Visit my site: http://www.drybonesuk.com

__________________
Visit my site: http://www.drybonesuk.com

Hi,

   Yes, you can capture user activity in many ways, and you can define an autoexec macro that runs when you open the app.

   For closing the app, what I would suggest is creating a hidden table and form, and have the form open when the database is opened (acHidden) and then for the form's On Close event, put in your closing code. I use hidden forms to track user activity and manage rights (since I have an app that runs on a machine that is always on with only one user account on the machine. I make each user log in to the app with security that I built into the app that does not use the integrated Access security - since every user shows up as Admin.)

   Anywho, does this help? Do you need code etc? I am sure other posters here have elegant solutions.

HTH


mmcdonal

thats great thanks very much.

i have a form in the database that opens on startup and closes obviously when you exit. the only way you can close the form is by closing access (except for using keys to close it but shh...), and the tracking is in the open/close event of the form.

so thanks very much! as for the rights you mentioned, i like that idea... i may have a think about implementing something like that myself...

thanks again

Patrick

Visit my site: http://www.drybonesuk.com