Yeah, tweak the registry, and ADE makes this easy with the Additional Registry Keys section on page three of the setup wizard. Here are the keys I want to set ...
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security [VBAWarnings] = dword:000001... and ...
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations [AllowNetworkLocations] = dword:000001... but where I got stuck is how to specify the data type of the Value parameter. The registry needs a REG_DWORD value or it has no effect. So after much googling I finally found the solution here at UtterAccess posted by Mr. Albert Kallal, who refers us back here to a useful Microsoft page.
And since this is the kind of info I'll use infrequently enough to forget, here's the secret.
Prefix #xBut it's a secret, OK. So don't tell anybody.
The value is interpreted and stored as a hexadecimal value
(REG_BINARY).
Prefix #%
The value is interpreted and stored as an expandable string
(REG_EXPAND_SZ).
Prefix #
The value is interpreted and stored as an integer (REG_DWORD)