How do I compare two databases for accuracy

[Guest]

I have two or more copies of the same database one on my PC one on a local
server and one on a remote server.
How can I compare them to see which one is the most up to date.

 

[Danny J. Lesandrini]

There's some old Access 97 code at my web site, compliments of Dave Rich,
that you may use for comparing Create/Modified dates of objects. Data is
a different question.


Access 97 Utility to compare Create/Modify dates of objects in two versions of the
same mdb file.
Created by Dave Rich and available at the Geotech Computer Systems web site.


http://amazecreations.com/datafast/GetFile.aspx?file=CompareDbs.zip

 

[John Vinson]

I have two or more copies of the same database one on my PC one on a local
server and one on a remote server.
How can I compare them to see which one is the most up to date.

That's almost impossible to tell. Suppose you have 23 tables in each
database; and in one of those tables Joe Schmoe's address is 123
Whitby Avenue and in the other his address is 987 Sudbury Lane.

Which address is "more up to date"?

Storing the same data in two different places is a guaranteed recipe
for trouble, for this very reason!

You may want to look into Replication (a complex subject requiring
careful implementation) or into having one database and using remote
terminal access rather than attempting to store data redundantly in
two databases.

John W. Vinson[MVP]

 

[Guest]

You might want to invest in this tool:

Total Access Detective (FMS, Inc.)
http://www.fmsinc.com/products/detective/index.html



Tom

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