Object Dependencies Error

[יריב החביב]

Hello,

When I try to use Object Dependencies option

in order to learn about the Dependencies of a query

I get an error mesage and access shut down.

What can i do ?

 

[Allen Browne]

IME, that's normal behavior for Access.

The 'object dependencies' functionality relies on Name AutoCorrect, which is
notoriously unreliable. I spent half a day trying to create code that looped
through the objects in a database to report the dependencies, in a database
that I knew had some bad dependancies (e.g. queries the relied on a table
that was no longer in the database.) I never did manage to get the code to
run to completion. Despite all the tricks in the book (repeated
compact/repair, decompile, import-into-new-database), it crashed every time.

IHMO, you're wasting your time trying to get it to work.

 

[יריב החביב]

Thank you allen,

somehow i click the office 'detect and repair' option

and it solve the problem.