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.