[AccessD] Track database changes

[John Bodin]

Hi David,

Not sure about free ones, but FMS has the Total Access Detective which sounds like exactly what you are looking for.  Used to be a few hundred bucks.  Might have a 30 day trial.  Good luck.

John

John Bodin
sBOR Office Systems
jbodin at sbor.com


________________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of David McAfee <davidmcafee at gmail.com>
Sent: Tuesday, April 26, 2016 1:19 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Track database changes

I'm in  the process of upsizing (to SQL), splitting, normalizing and
automating another user's Access (2003) database.

I made an initial copy of his database, to keep as a "base/starting
point" from when I started my process. This is going to take a few month to
do, as it isn't near the top of my priority, and there are something like
250 objects in his mdb.

As I make changes to my copies, I append the date to the mdb
name:(somename_yyymmdd.mdb). As I get to certain milestones, I'd like to
know what has changed on his end, as he is constantly making changes to his
database. He never creates forms or VBA. He only links to external tables,
local "temp" tables and queries. Is there some built in tool, or sample
code that anybody has that can compare my original "base" copy of his to
his most recent (and only) copy?  I don't care about data change, only
links, table structures and querydefs/sql .

Thanks,
David
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com