Merging Databases

[Maria]

I have 2 identical Access 97 Databases that the data has
been changed in each one and i would like to merge the 2,
does anyone know how to do this?

Thanks,
Maria

 

[Kevin3NF]

Is the structure the same in each, but the data is all different? Or are
some records identical in both, and you need to pick out the new ones?

 

[Maria]

The structure is the same in each, the data was the same,
but 2 people in the office updated different copies, so
now most of the data is probably the same but some of the
data is different but i am not sure which is the most
current one on each. I was hoping it might be
timestamped on the changes.
Thanks,
Maria

 

[Kevin3NF]

It will not be timestamped unless you created a date/time field and a
default, or some other mechanism to populate that field.

You are going to need to use a series of append and update queries to merge
these records together. The process itself is not all that difficult, but
can be extremely time consuming, depending on the size of your db, number of
tables, # of records, etc. Also, if this was straight data entry, it will
be significantly easier than if both were updating and deleting records
throughout the db.