• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Write object definition to a table (Access97)

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.
2 Solutions
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.

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 does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now