My client sent me her Access database (2007) to create new reports and queries. Unfortunately, between the time she sent me the database and when I created the reports, she made changes to the data in her copy (apparently not realizing that we now have 2 versions of the same database).
Now I need to find a way to completely replace tables from my version with tables from her version, without losing all the links based on the primary key. She doesn't remember what changes she made, so we need to completely substitute the data.
I've done this before, but I cannot seem to find an easy way to do this without possibly breaking the links and causing a whole host of other problems.
Please help (and thanks in advance)!
Now I need to find a way to completely replace tables from my version with tables from her version, without losing all the links based on the primary key. She doesn't remember what changes she made, so we need to completely substitute the data.
I've done this before, but I cannot seem to find an easy way to do this without possibly breaking the links and causing a whole host of other problems.
Please help (and thanks in advance)!