Access Clean-up

Question

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

Answer 1

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.

Answer 2

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.

Answer 3

Can you tell me what this means?

Answer 4

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

Answer 5

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.