Database Cleanup Project

[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

 

[Jeff Boyce]

Charles

FMS, Inc. (Total Access Analyzer), Black Moshanon (Speed Ferrett), Rick
Fisher's Find & Replace

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jerry Whittle]

As Jeff suggested, Rich Fisher's Find and Replace. The registered version has
a tool that can find 'orphan' queries and tables. The best $39 I ever spent
for working with Access.

However it sounds like you have a real mess on your hands. It just might be
the time to start over by defining requirements and building a new database.

 

[Paul Shapiro]

Others already suggested tools that can help with the process. Something I
find helpful once you have a reasonable understanding is to create a new
database. Import only the objects (tables, queries, forms, reports, modules)
that you know are essential. Test the features that your users use. Each
time something doesn't work, go back to the original database and include
the missing object(s). If your database is not already split, this would be
a good time to split it into the backend (data tables only) and the frontend
(everything else).