How analyze existing tables compared to developmental copy of database

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?
SteveL13Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
<<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
 
SteveL13Author Commented:
It's probably worth the cost.  Thanks.
0
All Courses

From novice to tech pro — start learning today.