Re: Bypass Security Warnings in Access Runtime

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

Date: 26 Jan 2005 20:30:49 -0800

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

  • [NEWS] IBM Informix Web DataBlade Local Root by Design
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
    (Securiteam)
  • Re: Access 2003 security warnings
    ... Security in Access is a misnomer. ... You can lock down the mdb files so that people can't get to the database ... Microsoft Access MVP ... Since I do not run 2003, perhaps you could tell me where the macro ...
    (microsoft.public.access.security)
  • Re: Create script to automatically send emails based on a query
    ... Also, in the macro window, what action do I select to run my procedure? ... shows all stored procedures in the current database". ... > The script is linked to a button on my switchboard that I have to> click. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2003 Macros warning
    ... There is no warning in 2000 and a warning ... You can to go Tools, Macro, Security and set it to low. ... IMO the best way is to start the database via a script file which sets ...
    (microsoft.public.access.gettingstarted)
  • Re: Command Button Wizard
    ... I was just trying to help you find the place to check Macro security. ... When the drop-down menu appears, drag it to Macro, then drop it in the sub-menu when that appears. ... Accounts, User Level Security Wizard, or Encrypt/Decrypt Database - these do ...
    (microsoft.public.access.formscoding)