Edited Records

[ejiro]

How can I keep track of edited records in access tables? Is is possible to setup access so that it tracks changes the same way changes are tracked in a WORD or EXCEL program?

 

[rewdee]

You can do this but it requires alot of code and there are no Access Wizards or menu items to do this. Essentially, it requires tables (depending how much detail you want to record) that records every AfterUpdate event the changes. Depending on the use of your application, the table will become very big very fast. If you want more information, there's an example at [

http://www.mvps.org/access/modules/mdl0021.htm

]



Bill Nielsen
Programmer/Systems Analyst

http://www.nielsensolutions.com