In order to make an AccDe from the AccDb I am working in, I first copy this
Db to say NewDb.AccDb. I then run the following

Dim AppAccess As Access.Application

Set AppAccess = New Access.Application
AppAccess.Visible = True
DoCmd.Hourglass True
AppAccess.AutomationSecurity = msoAutomationSecurityLow

AppAccess.SysCmd sCmd 603, MailMergePath, MailMergeMDEPath ' MailMergePath =
"NewDb.AccDB" ' MailMergeMDEPath = "NewDb.AccDE"
AppAccess.Quit acQuitSaveNone
Set AppAccess = Nothing
DoCmd.Hourglass False
DoEvents

Unless I have the line AppAccess.AutomationSecurity =
msoAutomationSecurityLow, it doesn't work. I am concerned that I may have
scrambled my security settings permanently, as I have no idea what the
original AppAccess.AutomationSecurity setting were.
Would welcome any suggestions of the "Default values" for these settings.
Thanks
Phil

On Sat, 5 Feb 2011 08:58:47 GMT, "Phil" <phil (AT) stantonfamily (DOT) co.uk>
wrote:

My understanding from the work I did in setting this up with the AUot
FE Updater is that the AutomationSecurity only applies to the
instance of Access that you are running at that moment in time. So
this shouldn't affect any security settings of the created ACCDE file.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On 07/02/2011 20:31:55, Tony Toews wrote:
Thanks, Tony

Seems to be OK

Phil