database window object descriptions

[Matilda]

Dear All,

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

 

[Steve Sanford]

Hi Matilda,

I don't have access to my code snippets, but maybe this will help:

http://www.accessmvp.com/djsteele/Documentor.html

HTH

 

[Douglas J. Steele]

Jeff Conrad, who actually wrote that add-in, has other alternatives at
http://www.accessmvp.com/JConrad/accessjunkie/doctable.html