This is what I have:
Mulitple ODBC connected SQL Server tables
Access 2000 front end
This is what I want to do:
Want to write a module that will do the following:
- Read the table and make a new table containing the following:
Field 1 TableName
Field 2 FieldName
Field 3 DataType
Field 4 Size
Field 5 Indexed?
I wish to make a data dictionary that lists all tables and all info about all fields in one single table - If I have to run it for each table and then append the results to one master table that is fine.
Does anyone know of a module, query or utility that will do this for me?
Thank you in advance.
John Kolker
Programmer
jwkolker@comcast.net
Mulitple ODBC connected SQL Server tables
Access 2000 front end
This is what I want to do:
Want to write a module that will do the following:
- Read the table and make a new table containing the following:
Field 1 TableName
Field 2 FieldName
Field 3 DataType
Field 4 Size
Field 5 Indexed?
I wish to make a data dictionary that lists all tables and all info about all fields in one single table - If I have to run it for each table and then append the results to one master table that is fine.
Does anyone know of a module, query or utility that will do this for me?
Thank you in advance.
John Kolker
Programmer
jwkolker@comcast.net