Compare Identical Database Tables

By | 2002-06-01

Contains One Class clsCompareDB and a Demo project.
Purpose: To compare two MS Access tables in different databases.
The code alse demonstrates: ADO Technique to retrieve the Table names from an MS Access Database using the Connection Object OpenSchema Method. ADO Techniques for using a recordset to retrieve Column Name, DataType and Size.
This class came as a result of MS Access being so easy to
Change. Before I Joined Tier Technology training I was employed by the United States Navy (DP1). Our Managers decided that the MDB file should not be locked in any way. We were requested to train the users what they can do and what they shouldn’t do. This gave no Guarantee though.
We had several programs that required that several tables in different databases (IE MDB’s for different years) be identical in every way. The procedures in question copied information of processed information by Column Index (Column position) or by using For Each (which also relied on the Column Position). Recently I needed this technique to do some debugging on an application I wrote for Tier Technology Training. So I dug this program up. Converted it to a Class and converted all DAO code to ADO code (Just to see if I could do this). Also this allowed this class to easily be converted for use with other databases (Other than MS Access).
Author: Joel Isenstadt(iteachvb@aol.com). I am a Microsoft Certified Trainer for Visual Basic and am Currently Employed by Tier Technology Training (www.tiertraining.com)

Original Author: Joel Isenstadt

Assumptions

How to use ADO. As in be able to connect to a database and create a recordset.

Attachments

FileUploadedSize
CODE_UPLOAD251312241999.zip9/3/2020 3:45:00 PM11552
Author: dwirch

Derek Wirch is a seasoned IT professional with an impressive career dating back to 1986. He brings a wealth of knowledge and hands-on experience that is invaluable to those embarking on their journey in the tech industry.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.