Re: Bypass Security Warnings in Access Runtime

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Overway (paul_at_I.hate.spam.logico-solutions.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 00:29:52 -0500

I've seen enough comments about the signed status being broken (like Scott's
post of yesterday), that I'll continue to shy away from macro security until
they fix it. Which is why my installer sets it to low. So, I've had no
complaints from 2003 users. For now, having macro security set to low is
the only way to be sure that the user doesn't get prompts and false alarms.

There is even more that they fail to tell you about getting a certificate
though....i.e., they "recommend" that you spend even more money to sign up
with Dunn & Bradstreet. And if you don't, odds are you won't get a
certificate or it will be for you as an individual only. Even if you do
sign up with D & B, you're not guaranteed to get a company cert. And then
guess who is liable? You, not your company. It really is a crock.

You might be right about the query issues, but I haven't verified it myself.
It should be easy enough to test the conditions you cited, even with a
selfcert certificate. 

-- 
Paul Overway
Logico Solutions
http://www.logico-solutions.com
"TC" <aatcbbtccctc@yahoo.com> wrote in message 
news:1106884592.973275.214680@f14g2000cwb.googlegroups.com...
> True enough. But certificates can also stop working & the prompts
> reappear.
>
> For example I *think* that modifying a query (programatically) will
> break the signed status. (Can you confirm one way or the other?)
>
> I've also wondered whether *compiling* a query (ie. when it is run the
> first time after creating or modifying it) would also do that. Yes? No?
>
> TC
>
>
> Paul Overway wrote:
>> Scripting may also cause prompts...from AV software.
>>
>> --
>> Paul Overway
>> Logico Solutions
>> http://www.logico-solutions.com
>>
>>
>> "TC" <aatcbbtccctc@yahoo.com> wrote in message
>> news:1106800249.620385.214820@z14g2000cwz.googlegroups.com...
>> > Paul Overway wrote:
>> >
>> >> You need to sign your application with a digital certificate or
> set
>> > macro
>> >> security to low.
>> >
>> >
>> > Why does everyone keep saying this?
>> >
>> > By far the easiest way is to start the database via a script file
> which
>> > sets the macro security level to low for that single invocation of
>> > Access. This does not require a certificate, or a registry change,
> and
>> > it does not affect any other database(s) - just the one being
> started
>> > by that script.
>> >
>> > Eg. in VBScript:
>> >
>> > dim o
>> > set o=createobject ("Access.Application")
>> > o.automationsecurity=1  ' set macro security LOW.
>> > o.opencurrentdatabase "full path to your database"
>> > o.usercontrol=true
>> > set o=nothing
>> >
>> > I've never packaged a system with the Access Runtime, but surely it
>> > should be possible to set it to start the system by running a
> script?
>> > HTH,
>> > TC
>> >
>

Relevant Pages

  • Re: Macro Security
    ... Many virus scanners alarm on any VB Script that is run...unless it ... which puts you back to getting a certificate. ... sign your app instead. ... Paul Overway ...
    (microsoft.public.access.security)
  • Re: Bypass Security Warnings in Access Runtime
    ... Paul Overway ... > by that script. ... > o.automationsecurity=1 ' set macro security LOW. ... > I've never packaged a system with the Access Runtime, ...
    (microsoft.public.access.security)
  • Re: Automation & Command line arguments
    ... It opens my db fine and starts to execute my code, ... then you need to have proper permissions to do this task. ... you need a macro security setting to low if you're going to have ... The beauty of the above protest is that the above windows script will ...
    (microsoft.public.access.security)
  • Re: Access 2003 - Security and Warning
    ... I have not created a certificate before for Access 2003 so I cannot be of much direct help. ... the macro security level to low for that single invocation of Access. ... Within the Microsoft Access help topic "Digital Signature" it details how ... > if to turn off the security and warning is need digital certificate, ...
    (microsoft.public.access.modulesdaovba)
  • Re: macro security & vbscript
    ... Macro security settings affect all VBA, which is what the "run a script" ...
    (microsoft.public.office.developer.outlook.vba)