How to know which Tables and Query's aren't used?

  • Thread starter Thread starter DraguVaso
  • Start date Start date
D

DraguVaso

Hi,

I have a whole bunch of old Access (97) applications with a lot of tables
and query's in, and a lot fo them aren't even used anymore.
Does anybody know a way to know which tables and query's aren't used in a
form/macro/module/query? So I can erase them from the Access-application?

I'm planning an upgrade to Access 2000 too, so if this could help to do it
it's a possiblity.

thanks a lot in advance,

Pieter
 
DraguVaso said:
Hi,

I have a whole bunch of old Access (97) applications with a lot of tables
and query's in, and a lot fo them aren't even used anymore.
Does anybody know a way to know which tables and query's aren't used in a
form/macro/module/query? So I can erase them from the Access-application?

I'm planning an upgrade to Access 2000 too, so if this could help to do it
it's a possiblity.

thanks a lot in advance,

Pieter
Click to expand...

You can look at relationships to find relationships.

I suggest you work backwards. Start with the output you want or need.
Then follow it back step by step to find what queries and tables are
involved with each path.

You can also use the documenter feature to give you a lot of this
information, but be sure your printer has lots of paper in it and plan on
looking over a lot of paper to analyze.
 
Rick Fisher's Find and Replace (www.rickworld.com) has a cross-reference
feature that can help with this. It's disabled in the shareware version, you
have to register to enable it, but it is very affordable and, in my opinion,
very good value for money.

FMS (www.fmsinc.com) and Black Moshannon Systems (www.moshannon.com) publish
more full-featured and, naturally, more expensive, tools.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
I would also suggest that even when you have done all of the aforementioned
and have identified objects that appear to be no longer needed or in use
rather than deleting them from the app right away just append _DROP to the
end of their name and leave them in there for a few weeks. If it turns out
that they ARE still needed somewhere that you missed eventually someone
will report a bug about it and you can simply change the name back. If a
reasonable interval yields no complaints then you can delete it.
 
Back
Top