finding all the changes made to a table

[the professor]

I had a student enter data through a form, but the changes are not in the
table. Is there a way to observe all times the table was updated? I would
like to identify if the data was really entered and then revert the database
back to that date or copy the data from the table.

 

[Scott McDaniel]

I had a student enter data through a form, but the changes are not in the
table. Is there a way to observe all times the table was updated? I would
like to identify if the data was really entered and then revert the database
back to that date or copy the data from the table.

This doesn't really have anything to do with Access User Level Security (which is the focus of this newsgroup) ....

Unless you've implemented audit tracking, then there is no way for you to determine who/what/when was entered/updated in
your tables. Access doesn't track this, and doesn't do change logs like SQL Server, Oracle, et al. You could, perhaps,
determine if the student logged into the machine (contact your IT department regarding this) but otherwise there is no
way that I know of.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com