Set security level to Low on the Security Level in Runtime?

B

Brian

Hello,
Is there any way at all to set the security level to Low on the Security
Level in the Runtime version of 2003?
I have a database with a macro that I want to schedule to automatically run
at night but it sticks waiting for you to click Open.
Thanks
Brian
 
A

Albert D. Kallal

Simply add the following keys to your runtime packing (the package wizard
does have provision for adding regs keys).

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001


If you add both of the above, then you get no security prompts at all...even
if the later jet sp8 is NOT installed. It is clean...and no prompts....

You could also export the above two keys to a reg file..and then run them on
that target machine to add the above values (would save you having to
re-install the runtime).
 

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

Similar Threads

Need Help with Macro Security 1
Set macro security level to 'low level' on opening a certain workbook. 2
User Level Security Enquiry 1
user level security 2
user level security 3
"Compile error in table level validation expression " after format 0
mde and user level security 8
avoiding the need to set Macro security level to Low 4

Top