Share via

Access Clean-up

Anonymous
2014-03-20T18:47:45+00:00

If there is a table and/or query that isn't being used and is not in a relationship then it is safe to delete it? Is there a way to tell if any forms or report are relying on those tables and/or queries?

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 No comments

5 answers

Sort by: Most helpful
  1. HansV 462.6K Reputation points
    2014-03-21T16:33:36+00:00

    The form must contain elements that the Object Depencies tool cannot handle - probably its Record Source. See http://office.microsoft.com/en-us/access-help/about-ignored-objects-mdb-HP006362742.aspx for possible causes.

    Was this answer helpful?

    0 comments No comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2014-03-21T16:33:16+00:00

    I'm not 100% sure, but it looks like You have a form that may be referencing the table in some way. So check that form and it it isn't then the table has no other dependencies.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-03-21T14:59:45+00:00

    Can you tell me what this means?

    Was this answer helpful?

    0 comments No comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2014-03-21T12:49:28+00:00

    You can use the Object Dependencies feature on the Database Tools ribbon to see if an object is being used by other objects.

    Was this answer helpful?

    0 comments No comments
  5. HansV 462.6K Reputation points
    2014-03-20T19:46:48+00:00

    Yes, if you are certain that the table or query isn't used for anything, you can delete it.

    If you have 'Track name AutoCorrect info' turned on (in File > Options, Current Database, Name AutoCorrect section), you can do the following:

    • Select a table or query in the Navigation Pane.
    • On the Database Tools tab of the ribbon, in the Relationships group, click Object Dependencies.

    Was this answer helpful?

    0 comments No comments