I have an Access table with 4500 records and more than 10 fields. (It’s a table that’s automatically generated whenever someone chooses to import it from the unigates.) Every 3 months, I print a hardcopy of 4 fields of this table and compare it to the last copy to find adds, deletes and changes to the records. It takes a VERY LONG TIME. Isn’t there a way I can save a copy of this table into a new table and compare 2 of them programmatically to tell me what’s changed? Maybe even using VB to look at each 1st field to find a matching record in the other table, and comparing the other 4 fields and only reporting records that have changed? I know some VB, but not how to use it with Access, so specific examples would be appreciated as to how Ican accomplish this task accurately without having to do it manually.
