Data Dictionary 1

[nateDiggsCSU]

I have two tables that I want to compare the fields and datatypes that are in them. I would like to print out something that shows all the fields in the tables and their data types. How can I get a data dictionary for each table?

 

[GingerR]

Have you tried the Documenter?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Take a look at the DAO.TableDefs and DAO.Fields collections.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244