Share via

Clean up database

Anonymous
2015-02-11T22:34:48+00:00

I started this database 10 years ago when I barely knew anything. It works fine, but I am sure I have tables, queries, forms, and reports that I no longer need. How do I set about cleaning it up? I have looked at the database tools but don't see any way to print from them. I am using Access 2007. Thanks.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-02-12T07:46:10+00:00

    Have a look at...

    Analyzer by Crystal

    http://www.accessmvp.com/strive4peace/Analyzer.htm (scroll down a bit to see it)

    Note, make a back up first.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-02-12T03:03:21+00:00

     I have looked at the database tools but don't see any way to print from them. I am using Access 2007. Thanks.

    Database Tools - Database Documenter - ...

    After selecting the what you want out and the options as to what charestics, clicking OK to display on screen, choose an icon in DATA on ribbon to produce an Excel, Word, or your desired format.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-02-11T23:04:51+00:00

    Well one first step could be to run the Object Depenancies option from the ribbon. Look for that button and it will show you exactly which objects depend on each other. That could be your starting point. Mind you that this does not mean that objects that don't have a dependency are the ones that are not being used.

    And of course the first tip would be that before you start cleaning up the database create a backup / copy of the db.

    Was this answer helpful?

    0 comments