Looking for tool to Compare two different mdb that will include all objects not just tables & queries

Can anyone recommend a freeware or shareware tool that will compare all objects and any differences between to Access databases.  The examples I have found on the web will compare the Tables, queries, but not the forms and code.

Any suggestion would be greatly appreciated.  Note I would love to have FMS tools, but it is a no go for my company.

Thanks,

Karen
Karen SchaeferBI ANALYSTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Luke ChungPresidentCommented:
Hi Karen,

Curious why our Total Access Detective add-in is a no-go for your firm.
0
Karen SchaeferBI ANALYSTAuthor Commented:
cost and not approved software.

k
0
Karen SchaeferBI ANALYSTAuthor Commented:
this is not a tool that will be continued to use - since my company is weening off MS Access for more web based tools.

K
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Luke ChungPresidentCommented:
The approved software issue is certainly a hurdle, but how would a shareware or freeware product be approved?

As for price in a corporate environment, I'm surprised how that's an issue when Total Access Detective is already so cheap, certainly compared to doing it manually or not getting the right answer.
0
Karen SchaeferBI ANALYSTAuthor Commented:
that's what I was tool by my manager -

Thanks,

K
0
Jeffrey CoachmanMIS LiasonCommented:
Karen,

As you know a big part of what Experts do here is to advise members not to "Re-invent" the wheel.

This is the case with many utilities:
DBPix
Rick Fisher's Find and Replace
Lebans PDF utility
PeterSoftware's ShrinkerStretcher
MZ Tools (VBA)
...and yes... Total Access Detective

The development cost of these tools is sometimes very high ...and you rarely get the same level of performance for "Free".

yes, ...Some things are interesting to do "Just for fun".
But a utility to compare DB objects would be to involved for experts here to to on a volunteer basis.

For a long time, no product even existed that did this,...and for good reason, ...it was just to complicated...

You can build your own *simple* utility to find/insert/display images in a DB...
(and possibly not need dbPix)

You can build your own *Simple* Email system....
(And possibly not need Total Access Emailer)

But I have never seen a post that detailed how to accurately compare Access database "Objects" or files...

IMHO, your Manager has asked for something that is just not very practical.

If a product does exactly what you want, why would it not be "approved"

Unfortunately, you could ague that almost anything "Costs too much", so, ...
How cheap would a highly specialized program have to be in order to be called "affordable"?
;-)

Finally...
What is the cost of you NOT having this ability?


;-)

Jeff
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Karen SchaeferBI ANALYSTAuthor Commented:
I agree 100%, but when you work for a big corp (aerospace) not mentioning names it is sometimes very complicated to get the software you need, ie. RED TAPE.

Thanks for you input.

Karen
0
Luke ChungPresidentCommented:
Hi Jeff: Thanks for the kind words.

Karen:

Sorry for the challenges you're facing.

We've probably sold our products to all the aerospace companies, or the software resellers they go through, so there may be copies already floating around in your organization.

As for aerospace and my personal self-interest, I sincerely hope y'all use the best tools for the job before delivering your products :)

Luke
0
Jeffrey CoachmanMIS LiasonCommented:
Luke,

Thanks, ...the other thing I like to make clear to members is that with utilities like yours, (and the others I posted), they get "Support".

With solutions here, (although we try to follow up), they are technically on their own.

In other words, I like to always point out when it is better to "buy" rather than "build"...


;-)

Jeff
0
Luke ChungPresidentCommented:
Thanks Jeff!

I'm always surprised how some organizations can't see value in a product that we offer for a few hundred bucks that cost us $100+K to build. Our fault for not making the perceived value more obvious.

Testimonials from experts like you certainly help establish the credibility of the 3rd party community who are delivering professional solutions. Much appreciated!
0
Jeffrey CoachmanMIS LiasonCommented:
Luke,

Yes, I think it bears discussing, (as also, Karen is a long time member here and asks some interesting questions...)


Luke, yes, as you know EE does not really like "Advertising" in the threads.
So, many experts have taken to stating:
   "I am not affiliated in any way to..."

As I stated:
 "anything can be thought of as being "expensive"
and:
"What is the cost of you NOT having this ability?"

Your products may seem to be out of reach for many new Access developers.
But they have to consider the real cost.

Sure, SendObject will send an email...
But it cant:
Use HTML
Attach multiple files.
Schedule
Bypass the Security pop-up
...etc

I look at it this way.
As a volunteer here, I will spend no more than 1 hour max, on a question
I value my high end development work at ($100 USD/hr)

So if I spent 5 hours of development time ($500 USD, ...the same cost of TAEM), would I really be able to create a comparable utility!?
:-O


I think not...
(And I'm being honest here, not patronizing,...)

So even if you take my (some would say, low) 100/hr rate,  ...$500 is "Cheap" for a product like TAEM.
As you know, some companies just seem to set some arbitrary number for "all" software.

Not saying that is the case here, ...again, I just think is is a good discussion...
;-)

Jeff
0
Karen SchaeferBI ANALYSTAuthor Commented:
Award points for Time & Effort
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.