[AccessD] Possible to set external ACCDB navigation properties through code

[Bill Benson]

Paul,

Am I able to do that without instantiating another Access Application? I am
trying to control everything through the DBEngine.

On Tue, Jan 29, 2019 at 3:15 PM Paul Hartland via AccessD <
accessd at databaseadvisors.com> wrote:

> Not sure about the system ones but for hidden objects you can try
>
> Application.setoption "Show Hidden Objects", vbfalse
>
> Paul
>
> On Tue, 29 Jan 2019, 20:10 Bill Benson <bensonforums at gmail.com wrote:
>
> > It does not appear that this setting can be done through Properties, and
> > this code snippet does not appear to discover such a property.
> >
> >
> > Sub DisplayProperties()
> > Dim db As DAO.Database
> > Dim Props As DAO.Properties
> > Dim iProps As Long
> > Dim iProp As Long
> > Set db = CurrentDb
> > Set Props = db.Properties
> > iProps = Props.Count
> > For iProp = 0 To iProps - 1
> >     Debug.Print db.Properties(iProp).Name
> > Next
> > End Sub
> >
> > Results:
> > Name
> > Connect
> > Transactions
> > Updatable
> > CollatingOrder
> > QueryTimeout
> > Version
> > RecordsAffected
> > ReplicaID
> > DesignMasterID
> > Connection
> > AccessVersion
> > NavPane Category
> > HasOfflineLists
> > StartUpShowDBWindow
> > StartUpShowStatusBar
> > AllowShortcutMenus
> > AllowFullMenus
> > AllowBuiltInToolbars
> > AllowToolbarChanges
> > AllowSpecialKeys
> > UseAppIconForFrmRpt
> > UseMDIMode
> > ShowDocumentTabs
> > AllowDatasheetSchema
> > Show Values in Indexed
> > Show Values in Non-Indexed
> > Show Values in Remote
> > Auto Compact
> > Row Limit
> > ANSI Query Mode
> > Picture Property Storage Format
> > NavPane Closed
> > NavPane Width
> > NavPane View By
> > NavPane Sort By
> > Build
> > ProjVer
> > AppTitle
> > StartUpForm
> > Show Values Limit
> > DesignWithData
> > Show Navigation Pane Search Bar
> > Theme Resource Name
> > WebDesignMode
> >
> >
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>