Tables and Queries...

[ChrisM]

Hi,

Ok, so I've got an Access DB with maybe 40 tables, and maybe 200 queries. Is
there a quick and simple way of working out which queries reference a
specific table? I believe that some of the tables may be redundant, but I'm
a bit nervous about deleting them just in case a rarely used query makes a
reference to one.

I'm hoping the answer is not that I need to open each query in 'edit' mode
and visually check what tables are referenced... :-/

Thanks!

 

[Guest]

Right click the table and select Object Dependancies from the drop down list.

I am using Access 2003, not sure about other versions but would imagine it's
the same.

Stu

 

[ChrisM]

In message (e-mail address removed),

Right click the table and select Object Dependancies from the drop
down list.

I am using Access 2003, not sure about other versions but would
imagine it's the same.

Stu

Oops, should have said. I'm using Access2000.
Which doesn't seem to have an 'Object Dependancies' option in the
right-click menu.
I'll investigate round that solution though...

Cheers,

Chris.