Comparing Databases

[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

 

[Milan]

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

 

[Tony Toews]

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.

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