How do I delete a dependency

[sean]

I downloaded the issues database and deleted a bunch of it. It is still
generating error messages saying I have a missing form. I checked the
dependencies window and it says there are some dependencies there, but I
can't find them in any properties window of any field or object, they don't
appear anywhere I can find in the design view. They don't appear in the
relationships window. Where else can I look?

How do I delete a dependency that is hidden somewhere? Is there anything
that will show me where Access thinks a dependency exists?

 

[Steve]

What do you do just before getting the error message?

Steve
(e-mail address removed)

 

[Arvin Meyer [MVP]]

You may have to start again. First turn off AutoCorrect. Then open the
Relationships window and Show All Relationships. Delete any relationships
for tables that you are going to delete. Next open each query in design view
and delete the tables you intend on deleting. Now delete the tables. You're
still not done. Open each form and delete each text box or other control
that has #Name in it, or that prompts for the name of the field. Now do the
same for reports. Finally, repair and compact the database.