How to merge 2 identical databases

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

compujacks

Thread Starter
Joined
Nov 28, 2011
Messages
1
Hello.

Recently, our ingenious IT folks at company HQ resized a virtual partition to allow us more space on our file server. Everything went well except that they brought down our backup set from 11-18 instead of what we needed, which was 11-27. Luckily, they saved a copy of our old shared drive on the actual server itself, so I have the old data I need. Which brings me to my question:

How can I merge two identical Access Databases so that I can get the older records to merge with the newer records/database so that I have everything I need. Right now the gap is from the 18th to today.

This is probably relatively simple, but I'm really not an IT guy (more of a garage tech).
 
Joined
Jul 29, 2001
Messages
21,334
Just import the records that are missing. It may be more involved than that , but that is the gist of it. Just start where the old records leave off and import anything after that point
 

OBP

Joined
Mar 8, 2005
Messages
19,896
compujacks, welcome to the Forum.
The difficulty of what you want to do depends on how many tables are involved.
I am not sure what you mean by "Right now the gap is from the 18th to today", is that data on it's own or is there a database with all the data up to the 28th?
If it is on it's own you need to import the table(s) and then append the data to the current historical tables.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
Rockn, sorry I didn't see you post as I was typing.
The OP may need to set up a method of identifying changes after the 18th.
Also the tables may need to be Appended in "order" to get the correct Key field links.
 
Joined
Jul 29, 2001
Messages
21,334
They could create some queries to find any new entries after the 18th or PK's > then the last number in the table in question on the old DB. With multiple tables and foreign keys this may be an issue. Make a backup of both prior to doing anything.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top