How do I delete a dependency

  • Thread starter Thread starter sean
  • Start date Start date
S

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?
 
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.
 
Back
Top