cmd MS Access 2003 macro security disable

  • Thread starter Thread starter meyerryang
  • Start date Start date
M

meyerryang

I want to change the macro security settings using a .cmd prompt. I don't
like it when Users have to go to Tools - Macros - Security to move the
security to low everytime they get a new image or open my app. I would like
all Users of my application to have it automatically set it as low security
when they first install (copy over) the application using a .cmd prompt.

I have gotten this far on my .cmd prompt, but I keep getting errors and it
won't work. In the notepad I enter:

REGEDIT [HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\OFFICE\11.0\Access\Security]
"Level" = DWORD:#00000001
 
Take a look at signing your project with a digital cert rather than trying to
programmatically set the security (I think the system is resiliant against
this... for security reasons (go figure)), and then add the publisher (you)
to the trusted list to avoid having security dialog popup without having to
change the level.

I have a link for how to do this but it must be at my house rather than here
because I don't see it in my list.

I can report back in a few hours with the link if you can't find one.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
I was able to get it to work. I appreciate your feedback. The problem is
some Users will have as many as 500 MS Access Databases on their systems (no
idea why), but it would be easier to disable macro security alltogether and
do it automatically.

As you said, regedit was the not correct so I removed it and got it to work
(duh).

I created a text document and named it disablemacrosecurity.reg
For those interested the solution was then to have the underlying code
entered into the .reg file (it is case sensitive):
___________________________________________
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Jet\4.0\Engines]
"SandBoxMode" = dword:00000002

[HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\11.0\Access\Security]
"Level" = dword:00000001
___________________________________________

Thanks again.

Douglas J. Steele said:
As far as I know, that's not valid syntax for REGEDIT.

Check what Jeff Conrad has at
http://www.accessmvp.com/JConrad/accessjunkie/macrosecurity.html for
alternatives for what you're trying to do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


meyerryang said:
I want to change the macro security settings using a .cmd prompt. I don't
like it when Users have to go to Tools - Macros - Security to move the
security to low everytime they get a new image or open my app. I would
like
all Users of my application to have it automatically set it as low
security
when they first install (copy over) the application using a .cmd prompt.

I have gotten this far on my .cmd prompt, but I keep getting errors and it
won't work. In the notepad I enter:

REGEDIT
[HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\OFFICE\11.0\Access\Security]
"Level" = DWORD:#00000001
Click to expand...
Click to expand...
 
Back
Top