List of queries and the tables they affect

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Is there an automated way to get access 2000 to list all
of the queries in the database along with the tables that
they create or affect?
 
You can use the Documenter to get table information. However, there isn't
anyway to get a list of all the queries without writing some VBA code.
 
You must log in or register to reply here.

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

Counting multiple memberships 1
VBA - retrieve data on last create named range from previous inserted named range 0
Creating a Select Query 1
List of tables not appearing on append queries or importing from E 1
Importing from excel issue with upgrade to office 2007 1
Make table query only runs from design view. 3
OnePlus January 19 Credit Card Security Update: up to 40k customers may be affected 2
combining queries. 4

Back
Top