How do I print the properties (data store) of the tables in my database.

If you just want a list of the tables, try this query:

SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;

Include type 6 for linked tables, and 4 for ODBC linked tables.

If you wanted to know how to list the fields and their properties as well,
see:
http://allenbrowne.com/func-06.html

If you want to document them, there is a built-in documenter under:
Tools | Analyze
or a better one at:
http://home.bendbroadband.com/conrad.../csdtools.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mary" <(E-Mail Removed)> wrote in message
news:79CE2F55-897D-423F-928C-(E-Mail Removed)...
> How do I print the properties (data store) of the tables in my database.