Recent changes logged

[Guest]

Is there any provision in Access for logging recent changes to the data? I
am tweaking my database and I think I just lost/modified one record. Is it
possible to find out which one of 3322 records got changed?

 

[Guest]

Hi,
no I believe that is not possible.
Normally you would have to implement a custom audit trail solution which
loggs when what was changed by who.
But...There is a possibility that if you did not close or compact your
application yet to retrieve deleted things. I don't know if it will work for
single records though.
Have a look at:
http://support.microsoft.com/kb/q209874/
HTH
Good luck

 

[Guest]

You can't decipher which record got changed after the fact, unless there is a
field that has a time stamp.

Moving forward, you can incorporate changes by stamping a record with =Now()
or similar.
You can also see http://www.mvps.org/access/modules/mdl0021.htm

Danny

 

[(PeteCresswell)]

Per Rod Smothers:

Is there any provision in Access for logging recent changes to the data? I
am tweaking my database and I think I just lost/modified one record. Is it
possible to find out which one of 3322 records got changed?

None. That's one of the reasons somebody might want to go to a Client/Server
back end: logging changes automagically via triggers.