schema objects 2

[DBrack]

Hello all,

Could I get a list of all schema objects - tables, forms, queries using a query or tool. I am just looking for a list of schema objects into a textfile. Thanks in advance

 

[dhookom]

You can get much of this by querying the msysObjects table:

SELECT *
FROM msysObjects;

If you need table structures etc you can run the documenter.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Have a look here:

http://www.jrbarnett.freeserve.co.uk/mdbdoc.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886