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.