What queries / tables are used?

[Duncs]

I've inherited a database that c100 queries and c 50 tables. What I need to know is, what queries / tables are actually used? Short of going into each query individually, I don't know of another way to do it.

Can anyone help?

Duncs

[Imdabaum]

There are others that might have better methods of doing this, but there is the Object Dependencies feature that lists all objects that are related. So if you click on Query1 and hit the Object Dependency button in 2007-2010 from your Database Tools tab or highlight the table/query and select object dependencies from the "right click menu" in 2003(Not sure about versions previous to 2003).

You can then see all objects that depend on this object as well as all objects that the selected item depends on.

For all the objects that don't have dependencies do a Ctrl+F in the VBE select radio button "Current Project" and type each object name manually to see if it is used in the VBA code. HTH.

[Duncs]

Cheers for that. I'll have a look at it and let you know how I get on.

Duncs

[Imdabaum]

Swimmingly hopefully.