Synchronizing two copies of same database

[Carl]

Hi Folks --

I'm trying to help a user who finds themself in this situation:

They have been working in a MSAccess database on a networked drive.
A few weeks ago they wanted to create a shortcut to it on their local drive.
What they did instead was copy the .mdb file to their local drive.
And, wouldn't you know, they've been doing work in both databases for
the last few weeks . . .

My question:

Is there *anything* I can do at this point to synchronize the two
databases "retroactively"?

 

[Guest]

Hi Carl,

Perhaps this article will be helpful to you:

How to Merge Records from Two Identical Access Databases
http://www.databasejournal.com/features/msaccess/article.php/2236471


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Carl]

I will check that out.
Thanks for your time -- I appreciate it.

Carl

 

[Guest]

You're welcome....and good luck.

A tool that you may be interested in looking into is called Total Access
Detective by FMS. It's not free, but it is a very good tool for locating
differences in objects and differences in data.

http://www.fmsinc.com/products/detective/index.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________