AnalyzeTables2K.mdb |
Post Reply |
Author | |
Beth Moffitt
Contributor Joined: 30 Jun 2008 Status: Offline Points: 1 |
Post Options
Thanks(0)
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/AnalyzeTables2K.zip |
|
--
Email: beth@houston.rr.com This database may be used royalty free as long as the commented information in the module stays intact. |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |