Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

Closed Thread
Thread Tools Rate Thread Display Modes
Old 04-29-2007, 09:25 PM   #1
Join Date: Nov 2002
Location: Camarillo, CA
Posts: 7,087
Thanks: 6
Thanked 56 Times in 54 Posts
WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough
MDB Table Comparison Tool

This was just a little exercise in VBA.

I hadn't seen any table comparison programs, so I decided to write one.

I wrote this without much planning. More than anything I'd like to
hear about design issues. I made some initial assumptions and didn't
change a thing while building it.

1) Link to the target tables.
JET SQL doesn't support multiple "From Table In 'c:...'
Therefore at least one of the tables must reside in the local DB.
Are linked tables the best approach?

2) Require a primary key.
If the table has no primary key, I'd have to treat ALL fields as Primary
Keys. Any data mod is a Deletion/Insertion.
Without a Primary Key the table is tossed out.

3) Max of 10 Primary Keys.
Arbitrary, seemed more than generous.

4) Limit total fields displayed to 20.
Forms have limitations. I can't dynamically create fields because I'll
kill the form after a short time (total # of lifetime fields = 750 or so).
Plus, the Conditional Formatting can't be done programmatically.
The underlying display table can only hold about 80 or so records.

This seems to be the critical issue. It would be nice to see the number
increase, but 20 can be a lot. Also, a good bit of the logic involves
keeping the PKs + Chosen columns under 20. That's not good.

5) Display with Continuous Forms.
Would Datasheet view be better?

Any thoughts on the above would be welcome.

I don't know if I'm gonna spend much more time on this. I'd like to hear
about the Design, but I wouldn't mind hearing of (or seeing) a different

Attached Files
File Type: zip A2000TableCompare.zip (228.4 KB, 22416 views)

WayneRyan is offline  
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update number field in "many" table from autonumber field in "one" table sueviolet Forms 4 05-05-2013 02:30 AM
auto update field - form to table Old Timer Forms 2 06-24-2009 07:58 PM
Newbie needing Help MikeyBoi General 5 04-17-2006 01:32 AM
Query to fill in blanks within a table? Maybe some other way? robjones23 Queries 11 03-21-2005 03:10 AM
Help with Relationships and table design: Bill Harrison Tables 7 01-12-2005 06:44 AM

All times are GMT -8. The time now is 02:17 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World