[AccessD] No Macro--> Security

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Feb 21 00:48:37 CST 2006


Marty:

Some good ideas for a workaround.  Thanks.  Will copy the client. 

However, I'm still hoping the solution is as simple as a full install of 
Access.

Rocky


MartyConnelly wrote:
> Some other ways around this.
>
> To avoid the security message you have to set the security level outside 
> of Access before opening the database.
> You can create a VB script file with this code and start your app using 
> this. (Code is from an MS article)
> http://support.microsoft.com/?kbid=235422
>
> Const cDatabaseToOpen = "C:\<FileToOpen>.mdb"
>
> On Error Resume Next
> Dim AcApp
> Set AcApp = CreateObject("Access.Application")
> If AcApp.Version >= 10 Then
>      AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
> End If
> AcApp.Visible = True
> AcApp.OpenCurrentDatabase cDatabaseToOpen
> If AcApp.CurrentProject.FullName <> "" Then
>      AcApp.UserControl = True
> Else
>      AcApp.Quit
>      MsgBox "Failed to open '" & cDatabaseToOpen  & "'."
> End If
>
> Pete
> A couple of other ways around this.
>
> Get your network guy to change the following registry settings of the
> following key, should help you change the security level of the macro in 
> Access 2003. He should be able to change this globally across the 
> network for each client PC, there is even a way to do this from Access 
> VBA code using WMI with proper network permissions.
>
> HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level
>
> If the value is 1, then the macro security of Access 2003 is set to low.
> If the value is 2, then the macro security of Access 2003 is set to medium.
> If the value is 3, then the macro security of Access 2003 is set to high.
>
> WARNING: If you use Registry Editor incorrectly, you may cause serious 
> problems that may require you to reinstall your operating system. 
> Microsoft cannot guarantee that you can solve problems that result from 
> using Registry Editor incorrectly. Use Registry Editor at your own risk.
>
>
> Or
>
> You could also put this vbs code in a file to execute in a user's 
> shortcut. Just create vbs file and add to desktop shortcut.
>
> MyMDB.vbs
>
> Const cDatabaseToOpen = "C:\<FileToOpen>.mdb"
>
> On Error Resume Next
> Dim AcApp
> Set AcApp = CreateObject("Access.Application.11")
> If AcApp.Version >= 11 Then
>      AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
> End If
> AcApp.Visible = True
> AcApp.OpenCurrentDatabase cDatabaseToOpen
> If AcApp.CurrentProject.FullName <> "" Then
>      AcApp.UserControl = True
> Else
>      AcApp.Quit
>      MsgBox "Failed to open '" & cDatabaseToOpen  & "'."
> End If
>
> Rocky Smolin - Beach Access Software wrote:
>
>   
>> Bill:
>>
>> Thanks. That looks like it. Will forward to the client.
>>
>> Rocky
>>
>>
>> Bill Patten wrote:
>>  
>>
>>     
>>> I'm running out the door so didn't edit this from my personal tech tips, but 
>>> I believe the information you need is here.
>>>
>>> Bill
>>> To turn off or change security (macro blocking) go to tools/macro/security 
>>> and set.
>>> If the security tab is not there then you must go to customize and  set it 
>>> up/
>>>
>>> tools/customize/commands then rearrange commands then in the menu bar drop 
>>> down find tools!Macro and select Then select add find security and double 
>>> click. Move to where you want it and  say OK
>>>       
>> >from MS Help
>>     
>>> Change the security level for macro virus protection
>>> Show All
>>> Hide All
>>> Security  Because macros can contain viruses, be careful about running them. 
>>> Take the following precautions: run up-to-date antivirus software on your 
>>> computer; set your macro security level to high; clear the Trust all 
>>> installed add-ins and templates check box; use digital signatures; maintain 
>>> a list of trusted publishers.
>>>
>>> On the Tools menu, point to Macro, and then click Security. If you do not 
>>> see the Macro menu item under the Tools menu, or the Security menu item 
>>> under the Macro menu, click the arrows at the bottom of a drop-down menu to 
>>> display the hidden menu items.
>>> Tip   If you want to see all menu items by default, on the Tools menu, click 
>>> Customize, click the Options tab, and select the Always show full menus 
>>> check box.
>>>
>>> I still can't see the Security command under the Macro menu
>>>
>>> On the Tools menu, click Customize, and then click the Commands tab.
>>> Click Rearrange Commands, select Menu Bar, and in the Menu Bar box, click 
>>> Tools | Macro.
>>> In the Controls section, click Add.
>>> The Add command dialog box will appear.
>>>
>>> In the Categories box, click Tools, and then in the Commands box, click 
>>> Security.
>>> The Security command will appear in the Controls box.
>>>
>>> Use the Move Up and Move Down buttons to position the Security command where 
>>> you want.
>>> If you'd like to position the Security command in its own group (between 
>>> horizontal lines), with Security selected, click Modify Selection and click 
>>> Begin a Group. Select the menu item below the Security command, and repeat.
>>>
>>> Click Close twice.
>>>
>>>
>>>
>>> Key Words
>>> access 2003 security macro
>>>
>>> ----- Original Message ----- 
>>> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>>> To: "Access Developers discussion and problem solving" 
>>> <accessd at databaseadvisors.com>
>>> Sent: Monday, February 20, 2006 4:12 PM
>>> Subject: [AccessD] No Macro--> Security
>>>
>>>
>>> Dear List:
>>>
>>> My user has four machines - one designated 'server' for the back end,
>>> three 'clients'.  He Put the back end of the app I developed on the
>>> server, and a copy of the front end on the three clients.  Two work OK
>>> after he got the security warning and went Tools --> Macro --> Security
>>> and lowered the security.  But on the third machine there's no
>>> 'Security' choice on the Macro sub menu.  Not even grayed out.
>>>
>>> Anyone seen this before and know how to fix it? (I have but I can't
>>> remember because I'm old and forgetful).
>>>
>>> MTIA
>>>
>>> Rocky
>>>
>>>  
>>>    
>>>
>>>       
>>  
>>
>>     
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list