Field Lists, Data Types and Comments

[knowshowrosegrows]

I have been asked to help some folks look at a very complex datbase that was
created by someone who no longer works here. He wrote good comments about
all the fields in the tables, but there are lots of tables with lots of
fields. They want me to do what sounds like the most simple task. Print
them a list of all the data fields that are collected in the database. I'm
sure this is possible, but I havent found tips.

Thanks for your feedback.

 

[Jeff Conrad [MSFT]]

Here are one or two options for you:

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[KARL DEWEY]

Another method might get you what you want is to use Access documentor.
Click on menu TOOLS - Analyze - Documentor and select all the tables. Click
on options and select the items you want.
After it is run you can send it to Word or Excel.

 

[Jeff Conrad [MSFT]]

That option is number one on the referenced page Karl.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Larry Daugherty]

Was there a request for assistance implicit in your post?

Look in Access help for "Documentor"

HTH

 

[knowshowrosegrows]

Yes there was an implicit request for help. That is how you and the other
people who replied knew to offer help....