dbs-properties.json changes

[jhgarrison]

I keep getting changes to dbs-properties.json, always to the same property. Here's the latest diff:

     "NavPane Closed": {
-      "Value": 1,
+      "Value": 0,
       "Type": 4
     },

This doesn't seem to correlate to the actual state of the navigation pane at the time of the export. It's currently definitely closed and hidden (completely invisible), but the diff is telling me it wants to record that it's not closed. It seems to toggle back and forth with regularity, every few exports, irrespective of the actual open/closed state of the nav pane.

As part of my application's startup code, and also prior to any export, I invoke:

Public Sub hideNavPane()
    On Error Resume Next
    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdClose
    DoCmd.RunCommand acCmdWindowHide
End Sub

So the nav pane is definitely closed and hidden.

Is there a reason this toggling back and forth happens?

[joyfullservice]

That's a good question... Technically the code is just reading the properties from the database object model, but I have noticed that the navigation pane properties do not always reflect the current state at the time that they are read. In my experience, some navigation properties only seem to be saved when the database is closed. 🤔 As a workaround I suppose you could potentially set that property in a BeforeExport hook so that it stays consistent in your export files. (I.e. CurrentDb.Properties("NavPane Closed") = 1)

[jhgarrison]

I tried closing and reopening the database, and even that didn't commit the change. But your suggested workaround does the trick. Thanks.