Solved

How analyze existing tables compared to developmental copy of database

Posted on 2014-02-06
2
129 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 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility
<<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
Comment Utility
It's probably worth the cost.  Thanks.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now