How to get object properties in a query - rather than Database Documenter

[robertsfd]

I have a large number of databases that I want to get various properties from to populate a spreadsheet. I can use the Database Documenter and hand input all the values that I want in the spreadsheet, but I can't imagine there isn't a way to query that metadata so I could import query results into the spreadsheet and save a ton of time.

I know I can export the results to Excel but they are still in a hard to use format such that re-keying the data would be easier than searching for the two individual items I want. Essentially I'd like the Date created and GUID items for every object.

Anybody know how to do this? I can't seem to figure out anything to even begin to get at it.

Thanks in advance.

 

[PHV]

Have a look here:

http://mdbdoc.sourceforge.net/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robertsfd]

Thanks, this seems useful. However, I no longer have access to an earlier version of Access. This apparently only goes through Access 2007 (I'm running 2010).

Perhaps I can get an earlier version so as to be able to use this.

Thanks for the help.

 

[PHV]

If it works for Access 2007 it should for 2010 too, I guess.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886