database window objects descriptions - accessing to print out

[Matilda]

Dear All,
( I am re-posting this from Programming as it did not attract a response
there)

Can anybody tell me how to print out the descriptions of all objects listed
in the database window?

There is an sql stmnt suggested in this forum:

SELECT MSysObjects.Name FROM MSysObjects
ORDER BY MSysObjects.Name;
which accesses the hidden system table, but a <select * > indicates that no
description included (same as documenter)

There is also an add-in available:
http://www.avenius.de/index.php?Produkte:Datenbankfenster

which looks promising but it is only for Access 2007 and my enterprise will
be remaining on Xp and 2003 for the foreseeable future.

Any suggestions?


Matilda

 

[david]

Iterate separately through the tabledefs collection, the queries collection
the forms collection and the reports collection.

For each object, print out the description property of the object.

"Description" is an OLE/COM property of each object, and not a
properly exposed data value. (Only Access 2.0 used a proper relational
data model for the Access project).

You will get an error if you try to print the description of an object
that does not have a description. You will have to handle that error.

(david)

 

[Matilda]

Many thanks, David

Iterate separately through the tabledefs collection, the queries collection
the forms collection and the reports collection.

For each object, print out the description property of the object.

"Description" is an OLE/COM property of each object, and not a
properly exposed data value. (Only Access 2.0 used a proper relational
data model for the Access project).

You will get an error if you try to print the description of an object
that does not have a description. You will have to handle that error.

(david)