Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I delete a dependency
0 views
Skip to first unread message
sean
Dec 18, 2009, 2:24:02 PM12/18/09
to
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?
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
Dec 18, 2009, 2:45:41 PM12/18/09
to
What do you do just before getting the error message?
Steve
san...@penn.com
"sean" <se...@discussions.microsoft.com> wrote in message
news:A8C4F33A-5E41-49B5...@microsoft.com...
Arvin Meyer [MVP]
Dec 18, 2009, 9:53:54 PM12/18/09
to
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"sean" <se...@discussions.microsoft.com> wrote in message
news:A8C4F33A-5E41-49B5...@microsoft.com...
0 new messages