any way to see what is using what?

[cnstarz]

Hello!

I'm wondering if there's a way for access to tell me what queries are using what tables; what forms are using what queries; what reports are based off what forms; etc etc. Can anyone help me out? Thanks!

[ajetrumpet]

on one of the tabs in the ribbon, there is a button called 'object dependencies'. Push it.

2010 is more descriptive than 2007, but I think your version can still print out a report .

[pkstormy]

There is also a product called FMS Analyzer which creates an extremely detailed report of every object in the mdb. I used it a few times in the past and it was extremely helpful. Especially logging and saving all this information into MSAccess tables. I'm not sure what the current price is but if you have a fairly in-depth mdb with a lot of queries and code, it might be worth the cost.

[RuralGuy]

And MVP Allen Browne has a number of useful routines down in the Utility section of this page: http://allenbrowne.com/tips.html

[cnstarz]

very good, thanks a lot guys!

[RuralGuy]

Want to use the Thread Tools and mark this thread as Solved?

[cnstarz]

done, son!