asked on

Clean up my Access File

I have a Microsoft Access 2007 file that I run my business on. I would like to clean up all the reports and queries that I don't use. Is there a good way to do this so that I don't end up deleting a querry that I didn't realize I was using somewhere?

ASKER CERTIFIED SOLUTION

pocketzz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Andrew_Webster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andrew_Webster

Dang yes, use Rick Fisher's tool, it's tremendous. I should have thought of that too.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

No to worry ... you posted to excellent links also ... I also use MZTools daily as well as F&R, and the FMS products often.

mx

Luke Chung

Hi Guys, Thanks for the nice plugs for Total Access Analyzer. Glad we live up to your expectations.
cansevin:
Our commerciial product, Total Access Analyzer, finds a lot of things to improve your Access databases and was created for situations like yours. We wrote a page focused on Finding and Deleting Unused Access Objects and Code
http://www.fmsinc.com/MicrosoftAccess/UnusedObjects/FindingDeleting.html
In addition to unused objects, we also catch:

Duplicate SQL strings (across queries, record sources, and row sources)
Unreferenced variables: variables assigned but never used
Scoping issues (procs that should be private rather than global)

Here's a complete list of the errors, suggestions, and peformance tips detected by Total Access Analyzer: http://www.fmsinc.com/Products/analyzer/ErrorsList.html
I think you'll find Total Access Analyzer paying for itself many times over. Good luck.