Object Dependency pane not showing (1 Viewer)

[Bobp3114]

In this database only, the Object Dependency Pane does not show even though I see the progress bar at the bottom of the screen doing its bit.

 

[June7]

And what is being done that the progress bar shows activity for?

What do you mean by the ODP "does not show" - does not show when db first opens? AFAIK, it isn't supposed to. Open it from the DatabaseTools tab on ribbon when you need to use it.

 

[Bobp3114]

I am opening it from the toolbar tab. I see the progress bar operating so obviously the "programme' is functioning but no pane appears to interact with

 

[The_Doc_Man]

There is something about your DB that is slowing down the evaluation. We can't tell from here what factors are driving the slowdown.

It could be a configuration issue, so is this a split DB or a monolithic DB? If split, how many files are involved? Have you attempted to build contributing files other than the main front-end file that contain code?

It could be a network issue, so whatever files are involved, where on the network are they with respect to your laptop or desktop machine? If this is a split DB, where are each of the files?

It could be a size issue, so how big is this DB? If this is a split issue, how big are each of the contributing files?

It could be a perpetual permissions issue caused by not having a persistent connection to one or more of the contributing files, thus requiring frequent repetition of the permissions evaluation procedure known as "access arbitration" (in this case, "lower-case a" on access.) Do you know what a persistent connection is, and do you use one?

It could also be a design issue, so do you have a LOT of deeply nested queries in this DB?

 

[Bobp3114]

Database is split
Not sure what a persistent connection is.
I work, adapt, make changes etc, to the front end on my home machine. I log onto the server to update the server.Users then log on to their virtual machines.
Database has grown quite large and as it has been created and adapted as the company expanded I need to get rid of the rubbish. Many aspects created early on are either superseded or no longer needed.
The only clue I have is that when first use of Dependency, I got a form come up that i could not decipher asking for info that i was unable to supply

 

[Bobp3114]

I have noted that when I click on the dependency icon the progress bar at the bottom of the screen says "searching for Dependency information"

 

[The_Doc_Man]

I got a form come up that i could not decipher asking for info that i was unable to supply

What did it ask you to provide? If it asked for a source for a given table, for example, that would be indicative of a spelling error in the name of some particular object. Like, but not limited to, spelling the name of a table incorrectly in a .RowSource or .RecordSource for a control or a form or report.

If you have to ask what a persistent connection is, you aren't using one.

Database has grown quite large

Quantify "quite large." How many KB, MB, or GB does it show when you look at the file in Windows Explorer with the Details option?

If you have a few years of now-obsolete objects, that will certainly cause you issues. Your problem of it asking you something you could not supply COULD be caused by having an obsolete object referencing something that has been replaced and the original object was deleted, thus leaving a dangling reference. Using "Object Dependency" methods to identify obsolete objects will not help much if you haven't deleted the obsolete objects because you will still find all the references you USED to use.

 

[Pat Hartman]

Have you tried the usual? Compile? C&R?