Query Table Properties

S

Spartanmba

Is there a way to query properties of a table(s)? I cannot seem to find an
answer. I am wanting to pull back the properties for each column that are
in a table.

Thank you,
John
 
K

KARL DEWEY

Try the TOOLS - Database Documentor
- click on the Tables tab
- select your table
- click options
- under Include For Fields select Names, Data Types, Size, and Properties.

Click OK, click OK. You can then take it out to Word for further review.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with "Latest Date" Query 9
Have both records from two queries/tables under one Query without related fields. 0
Using combo box in a form -- how to make drop-down work? 3
Query to update column in original table 2
Query to display highest totals 1
How to Retrieve Data From Another Access Dataase Without Linking to It? 1
Query performance Access 2007 1
Making changes 4

Top