VBScript to open secure database with command arguments

  • Thread starter rdemyan via AccessMonster.com
  • Start date
R

rdemyan via AccessMonster.com

In a previous post by TC, I learned that you can open an instance of Access
2003 and just for that instance set the macro security level to low.
Unfortunately, I don't have the link available, but here is the code.

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 would like to open a workgroup secured database and pass command arguments.
I would like to use VBScript as noted above so that I can reset the macro
security level. Currently, I am using the Shell command to open my workgroup
secured database and pass command arguments. How can I incorporate both the
VBScript included in this post with the Shell command I'm currently using.

Thanks in advance.
 
R

rdemyan via AccessMonster.com

In another post I learned that TC may have a workaround but only posted some
vague general directions. I have been able to open an instance of Access
from another access database with the /wrkgrp switch turned on. But I can't
get the OpenCurrentDatabase and automationsecurity feature to work.

TC, please help. I have all the workgroup security stuff figured out for
launching an instance of Access, with no database showing. I just need to
get the actual application launched while bypassing the macro security
warnings.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top