468,505 Members | 1,648 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

Compare 2 mdbs

has any one seen a program to compare mdbs'. I have ran into a few of
them, but none seem to really do that job.

Basically what I need to do is, take 2 access mdb's and check the
differences between the 2. i am talking about tables, forms, queries,
the whole ball of wax. Most of the programs jus do tables, that is
the easy part.

Also I was wondering how you would compate text fiels progammatically
and kick back a report using access/vba.

thank you for you assistance.

Vw
Nov 13 '05 #1
8 6489
On 4 Nov 2004 09:34:53 -0800, vi*********@gmail.com (Vincent) wrote:

Check with fmsinc.com - they used to have a tool to do it.
-Tom.

has any one seen a program to compare mdbs'. I have ran into a few of
them, but none seem to really do that job.

Basically what I need to do is, take 2 access mdb's and check the
differences between the 2. i am talking about tables, forms, queries,
the whole ball of wax. Most of the programs jus do tables, that is
the easy part.

Also I was wondering how you would compate text fiels progammatically
and kick back a report using access/vba.

thank you for you assistance.

Vw


Nov 13 '05 #2
Yah, I think they do have a tool, I have heard alot about it. But they
do not have a trial so I have way of trying it out. Any other tools that
you can think of.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3
Tom van Stiphout wrote:
On 05 Nov 2004 14:06:48 GMT, Vince West <vi**********@hotmail.com>
wrote:

No need for a trial. It works.


Lots of software out there that works, but until you try it you don't
know if it works for you.

I downloaded a free syslog utility for my firewall, it works, no doubt
about that. The one that came with my firewall also works, one works
better for me than the other.
Nov 13 '05 #4
CompareWiz does what you need; you can download a working copy (with
some limitations) from Software Add-Ins Web Site
(http://www.softwareaddins.com/CompareWiz.htm), CompareWiz support MS
Access 97, 2000, 2002 and 2003.

Ken Adams
Software Add-Ins
------------------------------------------------------------------------------
Software Add-Ins Products:

CompareWiz, MS Access Database compare utility.
(http://www.softwareaddins.com/CompareWiz.htm).

ReplaceWiz, Global find and Replace for MS Access.
(http://www.softwareaddins.com/ReplaceWiz.htm).

CompareDataWiz: Compare between MS Access data.
(http://www.softwareaddins.com/CompareDataWiz.htm ).

vi*********@gmail.com (Vincent) wrote in message news:<68**************************@posting.google. com>...
has any one seen a program to compare mdbs'. I have ran into a few of
them, but none seem to really do that job.

Basically what I need to do is, take 2 access mdb's and check the
differences between the 2. i am talking about tables, forms, queries,
the whole ball of wax. Most of the programs jus do tables, that is
the easy part.

Also I was wondering how you would compate text fiels progammatically
and kick back a report using access/vba.

thank you for you assistance.

Vw

Nov 13 '05 #5


Thank you for clearing that up Trevor. I really didnt want to have to
say that. And also i cannot justify buying something if I have not seen
it in action, espically when I have to write a propsal to my boss. The
first thing he will say will be have you tested it and what did you find
out.

Most cars work, did you just buy the first car on the lot when you went
car shopping. :)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #6
These are the programs that I have already looked at and why they do not
work:

This wil give you an idea of the kind of research i am doing, and will
be asked from my higher up.

Access2MySQL
-only compare and sync table

AccessCompare by Slofstraonly
http://www.slofstra.com/products/Acc...are/index.html
-only works for access 97 apparently

Beyond Compare
-only works for comparing text files

*********** CURRENT WINNER!!! ***************************
CompareWiz ( which is an add-in tool for M$ access0
http://www.softwareaddins.com/CompareWiz.htm

-this programs is the best i have seen so far
-but it gives me alot of useless results, about 5 useless things that i
have no clue what they mean
-this useless thigns like NameMap and GUID show up even if the databases
are the same
-It did find the code that was different which is huge
************************************************** *******

CDB Data Comparator
-only does SQL databases

Daodiff
-compares everyting but code, and skips the useless fields
-does not give an option to sync
-

exdemo2k

FMS Inc Total Access Detective
http://www.fmsinc.com/products/detective/
-there is no trail of this software package
-even thought i hear on the forums that this is a great tool

Klik! CompareLib
-cant get it to work for some reason

MDBDiff
-Decent program
-only does tables and queries

MergeIt2k
-

ObjectAsText
-this program will take you whole mdb and make it into a text
file, may be useful if i can find a program to compare text files
-does not current work for table structure

RepairDb Utility

SSW DataRenovator
http://www.ssw.com.au/ssw/datarenovator/
-

Visual Access Compare by Pragmatic Progamming and Lark Group
-only compares tables
-

XScompare by ChougleSoft
-compares tables, procedures, queries,
-does not compare code

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #7
NameMap and GUID are hidden properties that are used by access,
because CompareWiz iterate through all the object properties, hidden
properties which are usually used by access internally show up in the
result set, which is Ok because they are different, you can easily
filter out / delete these properties by double clinking the property
and check (Delete results for this property) this will delete all
simular properties from the result set
Ken Adams
Software Add-Ins
------------------------------------------------------------------------------
Software Add-Ins Products:

CompareWiz, MS Access Database compare utility.
(http://www.softwareaddins.com/CompareWiz.htm).

ReplaceWiz, Global find and Replace for MS Access.
(http://www.softwareaddins.com/ReplaceWiz.htm).

CompareDataWiz: Compare between MS Access data.
(http://www.softwareaddins.com/CompareDataWiz.htm ).

Vince West <vi**********@hotmail.com> wrote in message news:<41**********************@news.newsgroups.ws> ...
These are the programs that I have already looked at and why they do not
work:

This wil give you an idea of the kind of research i am doing, and will
be asked from my higher up.

Access2MySQL
-only compare and sync table

AccessCompare by Slofstraonly
http://www.slofstra.com/products/Acc...are/index.html
-only works for access 97 apparently

Beyond Compare
-only works for comparing text files

*********** CURRENT WINNER!!! ***************************
CompareWiz ( which is an add-in tool for M$ access0
http://www.softwareaddins.com/CompareWiz.htm

-this programs is the best i have seen so far
-but it gives me alot of useless results, about 5 useless things that i
have no clue what they mean
-this useless thigns like NameMap and GUID show up even if the databases
are the same
-It did find the code that was different which is huge
************************************************** *******

CDB Data Comparator
-only does SQL databases

Daodiff
-compares everyting but code, and skips the useless fields
-does not give an option to sync
-

exdemo2k

FMS Inc Total Access Detective
http://www.fmsinc.com/products/detective/
-there is no trail of this software package
-even thought i hear on the forums that this is a great tool

Klik! CompareLib
-cant get it to work for some reason

MDBDiff
-Decent program
-only does tables and queries

MergeIt2k
-

ObjectAsText
-this program will take you whole mdb and make it into a text
file, may be useful if i can find a program to compare text files
-does not current work for table structure

RepairDb Utility

SSW DataRenovator
http://www.ssw.com.au/ssw/datarenovator/
-

Visual Access Compare by Pragmatic Progamming and Lark Group
-only compares tables
-

XScompare by ChougleSoft
-compares tables, procedures, queries,
-does not compare code

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #8
I have to justify the purchase to my boss. The comparewiz v10.5 is not
a full functional version. Any other ideas? I am messing with teh
trial, but it only shows 3 items, and just tables and queries. It only
shows 30 items that were compared also. Do you think they will let me
have a fully functional version of the program or is there one available
anywhere?

thank you for the responses

Vince

*Dont Mind my Spelling*

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Deano | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.