printing a list of tables

Topic

New Reply

Access 2000 v9.0 how do i print a list of all of the tables and/or queries in my database?

Reply | Quote

Replies

Have you tried using the documenter? (under Tools)

Reply | Quote

Yes, however, in short this seems to miss the mark on what i’m trying to accomplish…i.e., it takes an unusually long time as it ‘examines’ each of the tables in my database (100+ tables). even when i go into tools/analyze/documenter/options and chose ‘nothing’ for “include for…table/fields/indexes” and then it prints a table name per page rather than a simple list of ALL of the tables in the database.

Reply | Quote

You can get a simple list of tables using this SQL:
SELECT Name from MSysObjects WHERE Type = 1
You can get a list of queries by changing Type to 5.
Hope that helps.

Reply | Quote

where/how do i do this?

Reply | Quote

Create a NEW query. Switch to SQL view and insert the parameters Rory gave. Switch to datasheet view for the results.

Reply | Quote

Fantastic…what can i add to the sql statement to also get the description?

Reply | Quote