Comparing Databases

  • Thread starter Thread starter George
  • Start date Start date
G

George

Is there a way to compare two databases? For example, I
want to compare a database file with a backup file. The
file date and times are different, but I want to
determine if everything else is the same. At a minimum,
I would like to compare the tables, but I'd also like to
compare all objects.

Thanks
 
There is a way, maybe someone has developed a tool for
that. It is not extremely hard but will take weeks of
programming. You have to go through all table defs, query
defs, forms, reports, macros and code and compare their
properties. But that's not it, you need to go another
level down (for table defs for example compare field defs,
for forms/reports compare all controls and their
properties.
Obviosly VB code is the easiest as you compare plain text.

Milan
 
George said:
Is there a way to compare two databases? For example, I
want to compare a database file with a backup file. The
file date and times are different, but I want to
determine if everything else is the same. At a minimum,
I would like to compare the tables, but I'd also like to
compare all objects.
Click to expand...

There are six such tools at the Compare two different Access databases
section at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top