By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,036 Members | 978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,036 IT Pros & Developers. It's quick & easy.

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

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.