X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Compare 2 Databases For Differences, Access 2003    
post Mar 28 2016, 08:10 AM

UtterAccess VIP
Posts: 4,434
Joined: 5-June 07
From: UK

I had 2 copies of a large database, and I wanted to determine whether any objects had changed between the 2 versions.

I wrote this module to store the created and last modified dates of all the objects. (Tables, Forms, Reports, Modules). Tables and Queries are both included in a single container.

This works in A2003. I have not tested it in later versions of Access.

The dbs contains 1 table to store the results, and 1 module containing the sub. It's very quick. My database has about 4000 objects, and all details were updated in less than a minute.

I was originally intending to connect to the database I wanted to compare (hence the columns in the objectlog table for remote database), but I couldn't sort that at short notice. Instead I just ran the same process in both databases, and compared both tables for differences.

Attached File  ObjectLog.zip ( 13.43K )Number of downloads: 130
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th November 2018 - 04:40 PM