Miss matched entries

[Trevor Howard]

Hello,

I have a service database for equipment. We have discovered a new user has changed existing data in fields by mistake, over a three week period. I have a backup backend which i know is fine.
How would i go about checking each record looking for changed fields based on my backup?
Thanks for any advice.

 

[CJ_London]

link to the tables in your backup, then create a query to compare two tables. Probably joining on the PK and the lots of 'OR' criteria. See this link to a recent thread has to how to do this

http://www.access-programmers.co.uk/forums/showthread.php?p=1510838#post1510838

 

[Trevor Howard]

CJ_London, Thank you for your help, that worked nicely.
thanks again