Hello,

I have a access database and in the database I have a table called Students.

If someone opens the students table and deletes the records how can I track what records were deleted and who deleted it.

Can i track the users computer name and record it in a log file.

Any ideas are welcomed.

Thanks

todd

You should keep your users out of the tables entirely. They should only interact through forms.

"Deletions" are best dealt with using a "deleted" checkbox field and the queries adjusted to not show "deleted" records except for the priviliged users.

Hello,

I have a access database and in the database I have a table called Students.

If someone opens the students table and deletes the records how can I track what records were deleted and who deleted it.

Can i track the users computer name and record it in a log file.

Any ideas are welcomed.

Thanks

todd

Hi Todd and welcome to the forum,

If possible you shouldn't allow users into the Students table as adviced but failing this you can use a log system, where you can track who has done what and at what time, with the option to reset.

You would need to use forms and some code.


I have attached a sample for you, you will have to look at the hidden objects and code by using Alt + F11 on the keyboard.

but even tracking who deleted stuff via a form is not so easy - as there are a number of ways that deltions can occur.

One alternaitve is to prohibit deletion. If a record is no longer required, just change a setting on the record to indicated it is now closed.

This is generally preferable anyway - as deleting records just means you completely lose any record of what happened while the records were live.