Can access tell me if I'm using a table or query?

[I_was_here]

I have a LOT of tables and queries and a few of them are not linked to
a form or a report and do not have relationships. Those few
tables/queries are probably junk and I want to throw them out. Is
there a way to tell or do I have to look at the record source of all
of my forms/reports?

Thanks!

[Larry Linson]

You can write code to do it, but there are third-party products that aren't
overly expensive and do a goog job of searching for and presenting all uses
of a particular string (e.g., the table name or query name) -- one with
which I have had very good luck is Speed Ferret from Black Moshannon
Systems, http://www.moshannon.com. Another is Rick Fisher's Find and
Replace, http://www.rickworld.com.

I'm sure there are others, perhaps even some free ones. If all you want to
do is find uses in Record Source, the code wouldn't be awfully difficult --
if for your own use, you could use Debug.Print to output to the Immediate
Window.

Larry Linson
Microsoft Access MVP
"I_was_here" <ks*****@yahoo.com> wrote in message
news:58**************************@posting.google.c om...

I have a LOT of tables and queries and a few of them are not linked to
a form or a report and do not have relationships. Those few
tables/queries are probably junk and I want to throw them out. Is
there a way to tell or do I have to look at the record source of all
of my forms/reports?

Thanks!