Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    We have an SQL 2005 database with an ODBC link to Access 2007. Is there an easy way to produce a list in either SQL 2005 or Access 2007 of the fields in each table with their main attributes (name, type, length) that we can paste into Word as a table?

  2. #2
    Lounger
    Join Date
    Apr 2002
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In Access 2007, click on the "Database Tools" menu and select the "Database Documenter" button. This will bring up a selection box where you can choose what you wish to document. If you click the "Options" button, you can select what you want printed.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Here is an access app that will do this for you. Just import all the objects into a data base (make sure you have a reference to Microsoft DAO 3.5 Reference - or later) and run the button on the form. You may like to go into the code behind the button and comment out the bits you don't want or it will document all of your forms, queries and reports as well.

    Or you can just link all of the tables into this database. It works for both Jet and SQL databases although the terminology for field names are the Jet ones. Eg Long instead of Int.

    But if you want you can fiddle with the select statement in TableDoc().

    Not only will it write the name and attributes of each table into tblSchemaTable and the names and attributes of fields into tblSchemaField

    but you can also use it to document your forms, queries and reports.

    Hope this does all you want and more.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •