This is an undocumented tip I found:
(Add once at start up and add this after every attach / link to external tables)
' hide the navigvation bar
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
-------
The above works because it points directly to the navigation pane. Just using docmd.runcommand acwindowhide may be unpredictible because it depends on what had the previous focus:
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo