Can i merge a "copied" DB with the origional 1

[Brownie13]

I have a DB on a network @ work. One of my Data entry people wanted to make a shortcut to the desktop and copied instead !!XXX!!X!
They've only updated certain rows/ cells (put missing info into them)not added any new rows. Is it possible to merge two DB's and not lose the edits/updates.
Or even just show where the difference in the two DB's are?
Any help with this would be great.
The structure of the tables in the different DB's are the same obviously.
Brownie

 

[HitechUser]

Brownie,

Here is a start. I assume you know how to link to the copied database. That being said now you need to compare the tables (possibly both ways)
i.e.

Olddb.table1 vs Newdb.table1
- and -
Newdb.table1 vs Oldbb.table1

Unless you assume that the Olddb has not changed, - anyway I degress.

Now try this link and link to both of your databases. Personally I have not used the sample, but most of the items on this site work GREAT!

http://www.rogersaccesslibrary.com/download3.asp?SampleName=CompareTwoTables.mdb

Hey it is a start..

Good Luck...

 

[Brownie13]

Thanks Hitechuser,
I'll let you know how it goes

 

[Brownie13]

Ok, I'm still pretty new to sql/vb how do i link two DB's?
Thanks in advance

 

[HitechUser]

Brownie13,

There are many ways... Since you are somewhat of a newbie... My recommendation (a simple one) is this...

Open the MDB you downloaded. Access will not allow two tables (linked or not) with the same name to reside in the same MDB. Soooooo being that you need to refernce both the Olddb and Newdb do the following.

From the menu select "File" > Get External data > link tables. This will bring up a windows dialog box. Locate your Olddb then select "open". This will bring up a another dialog box. From the tables tab highlight your table then select it. Now if you look at the MDB you downloaded your table will appear in the MDB with an error next to it (indicating a link). Note: if you now delete the table it really is just deleting the link.

Repeat the above steps and link to you Newdb. You will have to name it different than the first. Example - "tableo" and "tablen".

Now you the code you downloaded to compare the tables. Access will treat these as if the were local tables.

I hope this helps.

Good Luck...

 

[Brownie13]

Thanks so much for the time and info.
I'm bogged down right now but am excited to get on this.
Will keep you updated
Brownie

 

[HitechUser]

Hey,

Thanks! for the star..

I found a typeo (darn) it should say -

...your table will appear in the MDB with an ARROW next to it...

Sorry..