macro for finding tables used by queries

[David]

is there a way to find out what tables are used by queries
so unused tables can be deleted to clean up the database

regards,
David

 

[Steve Schapel]

David,

As far as I know, there is no direct way of short-cutting this within
Access. There are third-party tools available which can report on
object dependencies, including table involvement. One such is Total
Access Analyzer from www.fmsinc.com. How many tables and queries are
you talking about? In the end, it might just turn out to be best to do
it "manually".

 

[Guest]

Steve,

thanks for the reply , i am talking about 30 access
databases, with between 50-100 queries each and same
amount of tables, so i don't really want to do this
manually , i'll check ou the website though

thanks,
David