UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Merge 2 Databases Into One With All The Changes, Access 2007    
 
   
mmadani
post Mar 3 2018, 01:16 PM
Post#1



Posts: 319
Joined: 27-June 08



Hello Friends;

I accidently made changes to a copy of my database and the original one at the same time. Changes were made to code and to queries.

I lost track which is which only because I made a copy to my USB stick to work at it from home and the rest is history

Now is there a way to merge all of the changes into one database?


Any ideas? Please help.

Looking at the date of last update on the object will not help

Regards

Mike
Go to the top of the page
 
theDBguy
post Mar 3 2018, 01:23 PM
Post#2


Access Wiki and Forums Moderator
Posts: 72,439
Joined: 19-June 07
From: SunnySandyEggo


Hi Mike,

Nothing specific, just an idea...

One possible approach is to compare all query SQLs to find any mismatches. And for forms and reports, you could try using SaveAsText to compare them.

Just a thought...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
mmadani
post Mar 3 2018, 01:54 PM
Post#3



Posts: 319
Joined: 27-June 08



Thanks My friend. So basically I have to do it manually?
Go to the top of the page
 
theDBguy
post Mar 3 2018, 02:13 PM
Post#4


Access Wiki and Forums Moderator
Posts: 72,439
Joined: 19-June 07
From: SunnySandyEggo


Not really. The following should tell you if two queries are the same:

If qdf1.SQL = qdf2.SQL Then
'good
Else
'changed
End If

And as for the forms and reports, you can read the Text file into a variable and do the same thing. For example:

If strForm1 = strForm2 Then
'good
Else
'changed
End If

Hope it makes sense...

PS. Oh wait, yes, once you figure out which objects do not match, then you'll have to look at them and decide which one is the latest version. If both objects have changes, then you'll have to merge them manually.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Mar 4 2018, 09:06 AM
Post#5


UA Admin
Posts: 32,831
Joined: 20-June 02
From: Newcastle, WA


There is a tool available which does a very good job at comparing two databases, if you are willing to pay a license fee. Actually, probably more than one.

There is one from FMS, I believe, and one from Kellerman software called AccessDiff. I own the AccessDiff program because I frequently need to work on clients' databases that can, and do, vary from copy to copy. However, for a simple, one-off task like this, a more hands-on approach should be fine.

--------------------
Go to the top of the page
 
mmadani
post Mar 5 2018, 11:48 AM
Post#6



Posts: 319
Joined: 27-June 08



Thank to you George and Dbguy.

I found this software here not cheap though : http://www.accdbmerge.net/download , it looks good. but $75.00 per license

Much appreciated .

Mike notworthy.gif
This post has been edited by mmadani: Mar 5 2018, 11:59 AM
Go to the top of the page
 
theDBguy
post Mar 5 2018, 12:04 PM
Post#7


Access Wiki and Forums Moderator
Posts: 72,439
Joined: 19-June 07
From: SunnySandyEggo


Hi Mike,

Good luck! Please let us know how it goes.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    23rd June 2018 - 09:21 AM