How to find all queries related to a table

[shanmugamgsn]

Hi,
I use MS ACCESS 2003, i have hundreds of queries and tables.



I have a table A.
i want to find all qureries related to A, it may be update query, delete or insert anything. But how do i???

Please help me.

Thanks in advance

[pbaldy]

I have a tool called Speedferret, but Google a free utility called V Tools, which I believe has a search capability that will look at the queries. Actually, here it is:

http://www.skrol29.com/us/vtools.php

[Robeen]

Hi Shan!
I just googled 'dependencies' and found this:
http://office.microsoft.com/en-us/ac...001092965.aspx
I didn't even know it was there - but I know I will be using it on the databases I am currently using.

Hope this helps!

[Robeen]

I like pbaldy's recommendations.
Thanks, Paul!

[shanmugamgsn]

Hi PBadly...

I downloade V tools. and even opened it. But what should i do here after.. I can find many forms and modules????


Thanks,
Shanmuga,

[pbaldy]

No problem! I actually forgot there was something built in.

[shanmugamgsn]

I have a tool called Speedferret, but Google a free utility called V Tools, which I believe has a search capability that will look at the queries. Actually, here it is:

http://www.skrol29.com/us/vtools.php

Hi PBadly...

I downloade V tools. and even opened it. But what should i do here after.. I can find many forms and modules????


Thanks,
Shanmuga,

[pbaldy]

Because my employer had already bought Speedferret, I've never used V Tools. If I get a chance later I'll try and install it on a virtual machine and see how it works. Post back if you figure it out before that. I've pointed a lot of people to that site and it's worked for everybody. Given your description, I'd think you want to search for the name of the table, and see what queries it's found in.

[shanmugamgsn]

@pbadly
This V Tools looks like different DB. I have Different DB. how will this V-Tools DB will search my DB????

[pbaldy]

Did you follow the install instructions?