MS Access help: Comparing two databases?
I have a table with 90k records. I need to generate a report of changes made (or at least a of records changed) over the past week.
I have a back-up of the >Update:
Hi Brian - All the fields are the same (I haven't messed with the field names).
The primary key is "MemberID" on both tables. The data I'm looking for whether it's changed is the contact info, so "HomePhone" "WorkPhone" etc. There are other fields such as participating in certain events that I do NOT care if the data has changed, as this query is only for showing which records have had their contact info updated.
More Questions From This User See All
Answers & Comments
Verified answer
You could import the old table into the database under a new name and then do a query that way.
If you can tell me a field that is the same between the new version and the old, such as the primary key, and one (or more) fields that may have changed I'll show you how to set up the query.
Edit:
Okay, for your query, you will want to add the updated table. Just to make things simple I'm going to call the old table "old"
Add MemberID to the query. For the criteria type this:
In (Select MemberID from Old)
Add HomePhone to the query and make the criteria:
Not In(Select HomePhone from Old)
You can repeat those steps as needed for each field. You will want to put each changed field on a seperate "Or" line along with a copy of the MemberID criteria.
The results will only be the records that have changed.
Hope it helps!
You can use a software... "Beyond Compare" user friendly, it will help you alot. just google it.