Just in case any of you clever people has had this issue and found an elegant solution
I have written a classic FE/BE networked system where FE users all have an ACCDE file which has all of its shortcut keys disabled, the Navigation Pane hidden and a unique ribbon provided. This prevents anyone trying to look under the bonnet of the FE
However, I have noticed that when docmd.TransferSharePointList is run, the Navigation Pane automatically springs into life revealing all the hidden secrets of the FE
My inelegant workaround is to stop the screen from refreshing, hide all visible forms, re-hide the navigation pane, make all forms visible again before turning screen refresh back on however this still causes a noticeable flicker
Anyone aware if there is a better solution ?
This issue is happening in Access 365, W10 32-bit, W11 32-bit, W11-64bit
I have written a classic FE/BE networked system where FE users all have an ACCDE file which has all of its shortcut keys disabled, the Navigation Pane hidden and a unique ribbon provided. This prevents anyone trying to look under the bonnet of the FE
However, I have noticed that when docmd.TransferSharePointList is run, the Navigation Pane automatically springs into life revealing all the hidden secrets of the FE
My inelegant workaround is to stop the screen from refreshing, hide all visible forms, re-hide the navigation pane, make all forms visible again before turning screen refresh back on however this still causes a noticeable flicker
Anyone aware if there is a better solution ?
This issue is happening in Access 365, W10 32-bit, W11 32-bit, W11-64bit