Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Moffitt, Beth
Forum Description: Beth Moffitt's Library
Printed Date: 21 Mar 2018 at 1:31pm

Topic: AnalyzeTables2K.mdb
Posted By: Beth Moffitt
Subject: AnalyzeTables2K.mdb
Date Posted: 10 Jul 2008 at 3:44am
Import objects into current database and use the form to select tables to retrieve table/field information for analysis. Function will trap table name, field name, data type and field size. Table tblTestTypes is included for demonstration purposes only and can be deleted. A report is included for viewing results. This is in Access 2000 database using DAO, but can be upsized easily to XP. The code could also be copy & pasted into an Access 97 database.

Download Access 2000 (DAO): - uploads/29/


Email: -
This database may be used royalty free as long as the commented information in the module stays intact.

Print Page | Close Window