Track who opens a database

[Gary]

I have an access database on a network drive. Is there a way to tell who
opens or closes the database?

Better yet is there a way to track who might be deleting data?

Regards,
Gary

 

[GBA]

well there is nothing in terms of a vanilla feature inside Access that one
can just switch on.

but you can write some vba to manage this via an opening LogOn form;

you could use the User Level Security to control delete-ability - or write
their login code to the record....

it is a matter of creativity on your part more or less....

 

[Douglas J. Steele]

Check what Allen Browne has at http://www.allenbrowne.com/AppAudit.html