C
cbhamlyn
Hello,
I have inhereted a huge Access 2000 database with dozens of tables and
queries, most are backups of backups. There are about 30 queries that
run regularly, the rest are backups of how different queries used to
run.
Anyway, I'm trying to simplify the database by getting rid of tables
and queries that aren't needed. I've noticed several of the tables we
are going to keep have fields that don't seem to be used.
What I need to do is choose a field in a table and have Access look
through all the queries and tell me if/where that field is used.
I realize this probably isn't a built in feature, so is there some
secondary add-on or magic VBA code that might help me out?
Any direction you could give would be very helpful.
Thank you
Charles Hamlyn
I have inhereted a huge Access 2000 database with dozens of tables and
queries, most are backups of backups. There are about 30 queries that
run regularly, the rest are backups of how different queries used to
run.
Anyway, I'm trying to simplify the database by getting rid of tables
and queries that aren't needed. I've noticed several of the tables we
are going to keep have fields that don't seem to be used.
What I need to do is choose a field in a table and have Access look
through all the queries and tell me if/where that field is used.
I realize this probably isn't a built in feature, so is there some
secondary add-on or magic VBA code that might help me out?
Any direction you could give would be very helpful.
Thank you
Charles Hamlyn