Exporting table schema/relationship to text file

[vavroom]

Hello,

Using MS Access 2003, I need to figure out how to export the
information about the tables and their fields to a text file.

I have been tasked with rebuilding a rather big database and it would
be helpful to have a print out of each tables and what fields are in,
so I can do an analysis of it and speak to the DB users about what is
actually used or not.

I don't particularly like the idea of going through and doing it all
by hand. I can't seem to find a way to do that export.

Has anyone an idea on how to best accomplish this?

Thanks

 

[Allen Browne]

There is a built-in documenter: on the Tools menu in A2003.

Here's a better one:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

If you just want to pin down some things that might need attention:
http://allenbrowne.com/AppIssueChecker.html

 

[vavroom]

Thank you Allen,

The documenter, for some reason, I could not find! Doh. In any case,
you are right, the one on AccessMVP is brilliant. Thanks for that,
doing exactly what I need it to do.

Nic