473,573 Members | 2,749 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 7125
On 4 Nov 2004 09:34:53 -0800, vi*********@gma il.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**********@h otmail.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*********@gma il.com (Vincent) wrote in message news:<68******* *************** ****@posting.go ogle.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**********@h otmail.com> wrote in message news:<41******* *************** @news.newsgroup s.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
1351
by: Scotter | last post by:
Hi - I've got quite a few identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: (a) sync all MDBs designated to match one I've added some fields/tables to OR (b) tell all designated MDBs to have an...
8
1786
by: Bob Alston | last post by:
With all the recent discussions on ADPs and their lack of success, can someone point me to some GOOD reading on what is required to link MDBs to SQL Databases / Microsoft SQL Server 2000 Desktop Engine. Also are their any good, concise summaries of key differences that someone with Access/Jet experience would need to understand? Thanks ...
15
1959
by: Bob Alston | last post by:
Is it considered best practice to distribute FE databases as MDEs rather than MDBs? Without flaming me for asking the question, could someone please enumerate the key advantages? Also I like to provide my users a mini report writer where the report specs are stored as local data files. Can I do this in an MDE - e.g. have local data files...
0
1649
by: Silly Milly | last post by:
Calling ALL SSIS GURUS I am trying to import identical MDBs (Access Database) columns into SQL Server 2005 using foreach loop in SSIS. The data and file name of the MDBs are not the same; however the structure (column) is. I do need to capture part of the file name and insert it into the destination column (i.e. Year). I've used the foreach...
7
1586
by: Deano | last post by:
Got a bit of a major task coming up - I need to migrate data from one version of my mdb to another. Normally I manually track what's changed but there have been so many alterations it's been impossible to keep up. What I would like is some sort of tool to analyse two mdbs and give me a nice report showing the objects in each (mine will only...
0
7746
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8179
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6358
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5556
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3701
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2167
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1269
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
999
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.