Keeping records of updates in Access

[Noodles101]

Hi,

I need to keep a record of changes i make in an access DB. I.e, when i make an update to the price of an object identified by two fields, i want to keep a record of the date and time in the DB.
can this be done by creating another table?

Thanks

[RuralGuy]

Search for "Audit Log" or "Audit Table".

[missinglinq]

Allen Browne has a detailed explanation on how to do this:

http://allenbrowne.com/AppAudit.html

But be forewarned, this is not simple nor is there a simple way to do this!

Welcome to Bytes!

Linq ;0)>

[Noodles101]

Thanks for those. I think i'm going to try and go with the append records method. this will allow me to keep a record of everytime i make a change ( i'm the only one who is making the changes.)

I'll be back with more questions for sure though!!