dbTalk Databases Forums  

Access 2010 security

comp.databases.ms-access comp.databases.ms-access


Discuss Access 2010 security in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Phil
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.