Access database structure

[Dougharter]

I want to find the information on the fields in each database in an Access database. I need the Visual Basic code to get this information from the structure. I have Googled with no results. Can someone help?

[orange]

First approach: Database tools>Database Documenter


Graphic from Allen Browne site:

[Dougharter]

That helps, but I was hoping to get it using VB.

[isladogs]

Allen Browne to the rescue again.
This web page Microsoft Access tips: DAO Programming Code Examples (allenbrowne.com) contains several functions you can use
For example: ShowFields/ShowFieldsRS. You will also need FieldTypeName

[Dougharter]

That looks like exactly what I want. Now if I Can close this thread.

[orange]

FYI:
I attached some source code for a simple dictionary in this thread
a while back. It's simple but it may help.