Conrad Systems Development

Conrad Systems Development


  Home

  B.O.$.$

  Client List

Access Information
  Resources
  Calendars
  Corruption
  App Close Button
  Macro Security
  Kick Them Off
  Database Splitting
  Combo Boxes
  Tab Colors
  Progress Bars
  Backgrounds
  Navigation
  Command Buttons
  References
  Demo Database
  Form Resize
  TreeView Control
  Switchboard FAQ
  Matching Games
  Top 10 Lists
  CSD Tools
  Technical Articles
  Document Tables
  Calculators
  Shift Key Bypass
  Epson Printer Info
  Newsgroup Help

  Contact Us


                                 Document the table structures                              

A question that comes up in the newsgroups quite often is how to make reports that show the table structure. For example, the field names of each table and some of their properties. Below are some possibilities for making such reports.

1. You can use the built-in Access Documenter (Tools | Analyze | Documenter) to get a huge list of just about everything you ever wanted to know about the database. Be careful about what selections you make as the report could be quite extensive.

2. I created an Access Add-In that will document several areas of a database. One of the reports will list the table fields and a few properties of each. You can download the free add-in from this page:

CSD Tools

3. MVP John Viescas has some code and database objects that will do this.
Download some of his sample files from here:

  http://www.viescas.com/Info/links.htm#Downloads

4. David Hare-Scott has also written a simple table documenter. You can download it here:

  http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David

5. MVP Armen Stein has something here as well:

  http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

(Look for Data Dictionary Report Utility)

6. MVP Allen Browne has some TableInfo code here:

  http://allenbrowne.com/func-06.html

7. FMS has utilities that can do this as well:

  http://www.fmsinc.com/

8. Here is another Documenter option:

http://www.aadconsulting.com/ezdocprm.html

9. There is also a Documenter Utility here:

http://www.ssw.com.au/SSW/Download/Download.aspx?GroupCategoryID=2ACCESS

Look for SimpleTableDocumentor

10. MVP Arvin Meyer has something here:

  http://www.datastrat.com/Download/FieldDescription2K.zip

12. Ruben Vigon has a utility here:

http://www.mvp-access.com/rubenvigon/

(Look in the Aplicaciones area for mdb2doc 1.0.91)

13. Datafast Consulting has something here:

http://www.amazecreations.com/datafast/Download.aspx

(Look for Datafast Utility A97 & A2K)

14. Flexible Reporting of Documenter Results by MVP Duane Hookom:

  http://www.access.hookom.net/Documenter/

15. You can download tools that has a DocumentTables function (it's in the devTools module).
The code there loops through all the tables, and stores the table name, field names, and field size in
a separate table called DocumentTables. 

http://www.aislebyaisle.com/access/tools3.htm

16. Mark Liquorman has a Table Documenter rolled into his "Liquorman Utilities" here:

http://www.liquorman.net/tips.html

 


Top Top

Copyright 2005-2010 Conrad Systems Development - All Rights Reserved

This page was last updated on Sunday, September 19, 2010.

Site created with FrontPage