![]() |
Please consider donating $1 per sample downloaded, (find out why here) |
AnalyzeTables2K.mdb |
Post Reply ![]() |
Author | |
Beth Moffitt ![]() Contributor ![]() Joined: 30 Jun 2008 Status: Offline Points: 1 |
![]() ![]() ![]() ![]() ![]() 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 | |
![]() |
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 |