Print Page | Close Window

AnalyzeTables2K.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Moffitt, Beth
Forum Description: Beth Moffitt's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=162
Printed Date: 28 Mar 2024 at 2:12pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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): http://www.rogersaccesslibrary.com/forum/uploads/29/AnalyzeTables2K.zip - uploads/29/AnalyzeTables2K.zip



-------------
--

Email: mailto:beth@houston.rr.com - beth@houston.rr.com
This database may be used royalty free as long as the commented information in the module stays intact.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net