code needed to display a list of tables and fields used in queries

[BJS]

I have an Access 2003 database which contains hundreds of tables and queries. I need a fast way of getting the following information about the database:

1. List of all tables used by each query
2. List of all fields used by each query where underlying table name begins with "tblSQL"

Does anyone have code that will quickly provide this?

Greatly appreciate any help.

BJS

 

[georgedwilkinson]

As a matter of fact, there is a fantastic FREE add-on called V-Tools that has a module that will give you that information. Alot of the MVPs here have recommended it.

http://www.skrol29.com/dev/en_vtools.htm