Write object definition to a table (Access97)

Posted on 2004-11-24
Last Modified: 2012-06-27
Does anybody know if you can write an object definition to a table? For example: if you use the analyse->documentor feature, you can produce a report showing the properties and attributes of a table (or any other object) and all the fields (or columns as they are referred to) within it. I want to write that data to a table. The info I want to capture is:  field name, field type and field attribute for all fields in a particular table.

I have always assumed there is a sys table in Access that stores this information, but I've never managed to find it.
Question by:morema
    LVL 77

    Accepted Solution

    Hello morema,

    The documentor is of no use to you here.

    There is some sample code here:

    which creates a table of all properties, but as you will see it's quite long.  You should be able to modify it to select the properties you are interested in.

    LVL 12

    Assisted Solution

    Here is a question I participated in in the past, where the desired outcome was similar, with sample code:

    For what it's worth--hope it helps.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now