Re: Bypass Security Warnings in Access Runtime

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

From: TC (aatcbbtccctc_at_yahoo.com)
Date: 01/28/05 

Date: 27 Jan 2005 19:56:33 -0800

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: HELP! Need AD Query for Last login
    ... query the DCs in the USA domain, how would I modify the script? ... I'm new to VB script and making this simple modification is beyond me at ... >> ' Because the lastLogon attribute is not replicated, ... Then, for each Domain Controller, ADO is used to search the ...
    (microsoft.public.scripting.vbscript)
  • Re: LDAP query information
    ... a "Dim" statement. ... script is run. ... Microsoft MVP Scripting and ADSI ... Can you please provide me info on what to do with the below query? ...
    (microsoft.public.windows.server.scripting)
  • Re: LDAP query information
    ... execution of the vbscript? ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)
  • Re: LDAP query information
    ... The error message indicates the line number in the script, ... Dim strBase, strFilter, strAttributes, strQuery, adoRecordset ... Set adoConnection = CreateObject ... ' Construct LDAP syntax query. ...
    (microsoft.public.windows.server.scripting)
  • Re: An application, script, or AD Saved query that ...
    ... It is a multi-step operation as you can't create a query that says give me all users who aren't in a mail enabled group. ... So the most efficient way I can visualize this is that your script will need to find all members of all mailenabled groups. ... This you will enumerate the members and stick them in a hash/dictionary/whatever it is called in the scripting language you use, basically you want an associative array. ...
    (microsoft.public.windows.server.active_directory)