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