Document tables and their fields in a path...

[L33]

Hi,

This may be asking far too much and I strongly suspect a single, simple answer won't be forthcoming but I thought I'd put my wish-list here and see what sort of response I get. I need to document dozens of Access databases held on a shared drive, and what I'd like is some sort of tool (VBA-driven perhaps?) that I can point at the root of it and uncover the following info about every Access database it finds - here's that wish-list:

- Full file name
- Full path
- Name of each table in db
- Name of each field in each table

- Data Type of each field
- Description of each field (where one's been given, obviously)
- DB creator's name
- DB created date/time
- DB last modified by name
- Last Modified date/time

The first four are the minimum I'd like to get to, but it would be great to get the rest. Any pointers?

Many thanks in advance.

 

[alansidman]

Look at Crystal Long's Analyzer and see if that delivers what you are looking for.

Analyzer By Crystal

 

[L33]

Thanks for the quick response. It certainly looks like it will cover an awful lot, so I'll have a look in to that.

Thanks!