Access 2010 security -
02-05-2011
, 03:09 AM
Sorry. This should have been a new thread. Why it appears underAccess 2010
and Graphs, I don't know
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 |