Improve company productivity with a Business Account.Sign Up

x
?
Solved

How analyze existing tables compared to developmental copy of database

Posted on 2014-02-06
2
Medium Priority
?
143 Views
Last Modified: 2014-02-09
I have an old copy of an Access database and I have a developmental copy of the same database that has had tables and fields added to tables.  But I need o find an easy way to compare the two sets of tables/fields so I know what to bring into the existing copy without destroying any data.

Is there a way to do this?
0
Comment
Question by:SteveL13
2 Comments
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39839651
<<Is there a way to do this? >>

 Nothing built-in, other then you running the database documentor for each and making a compairison.

 There is Total Access Dectective:

http://www.fmsinc.com/MicrosoftAccess/DatabaseCompare.html

 which will do that for you.

 A third option would be to whip up some code to do it.  Not sure if you'd come out ahead $ wise between time invested and just buying Total Access Detective.

Jim.
0
 

Author Closing Comment

by:SteveL13
ID: 39845926
It's probably worth the cost.  Thanks.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question