Table Location

[Kosmo2]

Is there any easy way to find out which queries,forms or reports are using a specific table or tables ?? I want to ensure that if for any reason I delete a table or rename it, it wont mess up my queries . .


Thanks

 

[Steve101]

There is a fantastic third party product called Speed Ferret, which does cross referencing, global Search and Replace etc. You really cant go past this product, but ... I think it costs about $200.

Check it out at:

http://www.moshannon.com/

Hope this helps,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Kosmo2]

Thanks for the link Steve , Speed ferret certinly fits the bill but $200 is kinda steep , I was figuring on shareware or something in that line . . .

 

[Kosmo2]

Thanks for the link Steve , Speed ferret certinly fits the bill but $200 is kinda steep , I was figuring on shareware or something in that line . . .