Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Table or Query with table field names and data types. 1

Status
Not open for further replies.

rccline

Technical User
Jun 13, 2002
341
US
I would like to create a table that lists the field names and data types of my tables. Documenter give me too much information. Comparing two tables, I get 21 pages of information. I am looking for a simple table with "table name" "field Name" and "data type."

Can I create a query or table that does that in Access?

Thanks.

Robert
 
Have a look at the TableDefs, TableDef, Fields and Field DAO objects.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
You can use the documenter and then report results however you want by connecting to the documenter table. There are instructions at
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Thanks DHookom. What a great website & resource.

Robert
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top