Access Database mdb comparasion tools/utility

Hi All,

I am in need of a software or tools/utility which does the MS Access whole Databases (two .mdb files) comparasion including schema, tables data, forms, reports etc. Please let me know if there any automated tools/utilities that are available that does this.
thanks
sridhar_ravvaAsked:
Who is Participating?
 
Helen FeddemaConnect With a Mentor Commented:
Here is a screen shot of a page of the Table Fields report:
Table-Field-Report.jpg
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Probably what comes the closest is Total Access Detective by FMS, Inc.
http://www.fmsinc.com/MicrosoftAccess/difference/new-features/Access-2007.asp
They also offer Total Access Analyzer, which may be of interest.
JimD.
 
 
0
 
sridhar_ravvaAuthor Commented:
this tool is not free..and also its not providing the functionality which i want it...please suggest me some more solutions or tools/utilities for the ms access mdb files in terms of tables structures, forms, reports, queries, modules etc...actually i am not interested in the data comparasion between two mdb files. thank you.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
sureshchsahuCommented:
Just try the below link it is a 14 days trial version

http://www.kellermansoftware.com/p-33-accessdiff.aspx?mode=Trial&
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You're not going to find anything free that does this. I own both Total Access Detective and Total Access Analyzer, and I can guarantee you TDD will tell you the exact differences between two Access files (including data, if you want).

Rick Fisher's Find and Replace (www.rickworld.com) might be something to consider, as it does have a Compare utility I believe, but I'm not sure ... others have said it provides this sort of thing, but I own it and have not yet found where it can do this - but I don't use it as much as others.

0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
sridhar_ravva,
<<this tool is not free..and also its not providing the functionality which i want it...please suggest me some more solutions or tools/utilities for the ms access mdb files in terms of tables structures, forms, reports, queries, modules etc...actually i am not interested in the data comparison between two mdb files. >>
You did not say that you wanted a free tool and Total Access Detective does exactly what you want; compares two databases. As LSM said, your not going to find a tool like this for free.
Rick Fisher's Find & replace is a commercial product as well, but even so, it doesn't have the features you want. There is no comparison capability in the product. Closest you can come with it is to generate a cross reference for each DB and then compare manually.
Total Access Detective comes the closest to what you want.
JimD.
0
 
Helen FeddemaCommented:
My Extras Plus add-in (see link below) is free, and it will give you reports listing table and query fields, which may be of help (among other useful features, such as making backups of databases and individual objects within databases).
http://www.helenfeddema.com/Files/code20.zip
0
 
sridhar_ravvaAuthor Commented:
alternate solution found.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.