Possible to create an updatable query listing Description of tables and fields?

[Banana]

As I usually concentrate on building the tables and fields in my initial stage, and do some experimenting to analyze the relationship.

However, when I'm done, I find it quite a hassle to go manually through the tables to add description to each field for documenting.

What I would like to do is create a query that will list all fields and its description. Now, I have found codes to retrieve either table or fields properties, including the description property, but am kind of stumped on how I can make it a SQL statement so I can create a temporary query, which will be pretty be one time thing, that can read all fields' description and allow me to type in it, save it.

If that's not possible, I suppose I could write code, using Allen Browne's example, that would loop through the fields' description, debugging to the immediate window and prompting me if I would like to add something to the blank description. However, this isn't exactly greatest as I need to see all fields so I can be sure I'm giving good descriptions.

I figured someone may have had this same problem and maybe came up with a solution?

 

[philipavery]

Can't see how it can be done with a query but even if it could, why would it be quicker than opening and editing the table in design view?

 

[Banana]

Two reasons:

I'm talking about doing a collection of tables at once. Also, this would help me see what other table structure are, and allow for better documentation.

I guess that mean I'll just have to do it with VBA or temporary table then.

 

[philipavery]

No, I can't see an alternative but if you produce something limited to documenting and with a good interface it could have market potential. I document as I go but it would be useful for inherited databases. I did do something similar back along but used Excel as the interface.

 

[Pat Hartman]

You can use the tabledefs collection to obtain all the attributes of a table and write them to a table. You can then create a form bound to that table to view/update whatever you want. The problem is that you will need to apply the update via VBA since you need to update the collection. You cannot directly update any system tables.