Under File menu - view and edit (ms access) database properties allows you to see a list of all the Objects in the database - Is there a way to export this list?

Question

Under File menu - "view adn edit database properties" I can see all of the objects within the d/b.  In this particular example; I have a d/b w/ ~ 100 tables and ~ 100 queries, there's a couple macros but there are no modules, forms or reports; the d/b is mostly used for staging lots of transactional data.

Is there a VBA routine or some other way to export or print this list ???

I came across the following SQL statement; but the output or data sheet view of this function loses the Object descriptor; e.g., Table, Form, Query, Macro, etc, etc.

SELECT MSysObjects.Name, MSysObjects.Type

FROM MSysObjects

WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=5 Or (MSysObjects.Type)=-32768 Or (MSysObjects.Type)=-32764));

Thanks in advance for any ideas!!

Steve

Answer 1

Albert,

Thanks for the input.  I played with the Options a little bit; but in certain files it's almost easier to just run the SQL statement as a query which pretty quickly generates the list of contents by object type.  Not perfect quite like the file / menu / view properties but close enough.  In one example I turned off all properties all options other than just list table names; I ended up with basically one sheet per table w/ the file name at the top w/ no other details .... but I had 212 sheets; one for each table.  Ridiculous.

Good idea though to play w/ the options settings; and also with the Relationships / Object Dependencies.  You can do similar excercise in Excel with formula Auditing tools which allows you to see Precedents and Dependents.

Thanks/regards,

Steve