Aug 26 2009, 10:44 AM
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,
Aug 26 2009, 10:45 AM
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.
Aug 26 2009, 10:56 AM
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,
Aug 26 2009, 11:01 AM
To get strictly the names of the tables and queries, use
WHERE Type IN (1, 4, 5, 6)
AND [Name] NOT LIKE "MSys*"
Aug 26 2009, 11:07 AM
Amazing!! Thanks so much!!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here