ACCESS PROBLEM - Data has been split across two different copies of the same database

Question

  Hi,

     I have one Access Database that was copied over to a different file server that is brand new.  I disconnected the share from the old file server so that they couldn't get access to it, but someone was going through another share that I didn't see on the old server.

   So, some of the data is on the new copy of the access database and some is on the old copy on the previous server.

 

QUESTION #1:   

How can I find out what data is missing between the two databases?  

QUESTION #2:

How do I copy that missing data over to the new version of the database?

Answer 1

Hi,

One option is to link one front end to both back end files and use a query to compare the two. You can then use an APPEND query to add the missing records once you found them.

Hope it helps...

Answer 2

Right now there is no frontend/backend files, it's just two entire single access database files.  They are not split.  Yes, we will split them for performance reasons, but they are not split yet.

I don't know how to query the databases, is it the same as SQL, do I need to do each table?  Can you set up an example of what you mean?

Answer 3

Hi,

In your case then, you can link one database to the other and then compare the tables. If the data is spread in multiple table, then yes, you will have to examine each one.

You can try using the Find Unmatched Query Wizard to find the missing records, if you're not comfortable using SQL statements. Here's an example query:

SELECT * FROM Table1
LEFT JOIN Table2
ON Table1.PK=Table2.PK
WHERE Table2.PK Is Null

Hope it helps...

Answer 4

Hi,

Looks like you modified your original question. The above example I posted should answer Question #1. To accomplish Question #2, you might convert the above query into a Make-Table query and then use an APPEND query to add the records from the new table into the original table.

Hope it helps... 

Answer 5

Hi,

Looks like you modified your original question. The above example I posted should answer Question #1. To accomplish Question #2, you might convert the above query into a Make-Table query and then use an APPEND query to add the records from the new table into the original table.

Hope it helps... 

        Okay, I am not an Access wiz so I will google and play with this to see if I can get it all to work.  I will probably be asking questions later as I go through this.  :)

       Thank you for your help! :)

Answer 6

Hi. You're welcome. It's what we're here for. Just let us know if you get stuck. Good luck.