Automation & Command line arguments

Tech-Archive recommends: Fix windows errors by optimizing your registry

I've done a TON of looking and reading on this subject and have found some
ideas, but nothing that is working for me. I could really use some insight
here. Access 2003, XP

In a nutshell:

1. I want to open my app via a scheduled task.
2. I want to send the database a command line argument (in order to specify
which task to run).
3. I do not want the security warnings to come up.
4. I want my scheduled code to run (which, depending on the task, takes
between 30 seconds and about 2 minutes.)
5. I want the database to close.


I have tried to make a script with the code:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "mypath\mydb.mdb"
o.visible=true
o.usercontrol=true
set o=nothing

which bypasses the security but then hangs Access without completing the task.


Any help?

.

Relevant Pages

  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is it safe to use social securty number as intranet username? (long)
    ... > they expect us to use our social security number as a username. ... by some database application ... ... The gateway router runs radius for authenticating ... ISPs perform internet connection authentication) ...
    (comp.security.misc)