Hi all,

We have a big list of tables in an access file, and for documentation purposes we would like to take the list of names / queries that we have, and write down how they relate to certain reports. Is this possible? In 2007, we would need to right-click / rename the file to even be able to copy past 1 table name!

Hope this makes sense. Thanks,

Russell

I think the simplest would be to use the Documenter feature that comes with Access. You can also use the Object Dependencies button to get this data.

Edited by: fkegley on Wed Aug 26 11:46:43 EDT 2009.

Thanks, although it produces quite an amount of detail :( Could be worth a try, except we just want to document which queries / tables apply to reports we have going outside of access. Appreciate it. Cheers,

-R

To get strictly the names of the tables and queries, use

SELECT [Name]
FROM MSysObjects
WHERE Type IN (1, 4, 5, 6)
AND [Name] NOT LIKE "MSys*"

Amazing!! Thanks so much!!