How to check who and when access data was entered/changed?

[Charles Vaughn]

I have a Access database that is used by several employees for several different reasons. I also use this database to track and pay incentive for payroll purposes. I recently have had some incentive numbers being changed and want to be able to pin point who or at least when the changes were made. Is this even possible?

Thanks,

Joe

[Rabbit]

You can code a logging system into all the forms. However, that doesn't stop them from going in and modifying the tables directly. The only way around this is to obsfucate the data so the employee won't be able to make a change unless they know how the data was obsfucated.

[Jerry Maiapu]

In many of the databases I have created, I capture the details of the logged in user and the date a record was modified.

To do the recording you need to plan first.
Like Rabbit mentioned, first create a login form for users to log in, secondly, make all forms bounded to users table so that you can access the username or find other ways to atleast capture the username on your form, thirdly, have some buttons to save any changes made.
On the save button's on click event you can insert the username and today's date into a independent table.

Then use a datasheet form to display the records from table.

Just some hint there though there are many ways of keeping a log of changes made.
Hope this points you in the right direction.