Create Audit Of Records Added / Deleted To A Form

[TimTDP]

I have found users "cheating the system" by adding and then deleting records at form level!
What is the best method to create an audit of records added / deleted at form level?
The forms Record Selector is set to yes, so the user can select multiple records for deletion

Each user has a login, so I know who the user is that makes the changes!

I am using both Access 2000 and 2010. I am migrating to 2010 so would like to concerntrate on this version if it is easier. I am however new to 2010!

 

[Jim229]

According to what I have read on the Microsoft site you need to implement your auditing approach before you migrate to any Access 2007 or newer. According to the article I read Access 2010 format does not support this activity tracking but will accept it if you had it active before converting to 2010 format. It makes no sense to me but that is what the article stated as it directed me to read the audit Trail article for Access 97. GHudson posted a great thread that has grown beyond belief on this subject and I know the code he has posted works at least up to Access 2003 which is what I am using still with User level Security. I recommend you read the post in this thread. It is very Informative.