Within a form I am building the enduser a view of the existing tables I created within access. When the user clicks on a table name in a list object I want to show the attributes of the table (field names, data types and field size). What I'd like to know is how do I get the attributes in a query?
I'm pulling the tables names using the following query;
SELECT [MSysObjects].[Name], Left([DateCreate],10) AS Created, Left([DateUpdate],10) AS [Last Update] FROM MSysObjects WHERE ((([MSysObjects].[Type])=1)) ORDER BY [MSysObjects].[Name];
Thanks for any and all assistance,