August 1, 2005 at 7:47 am
Hi
I've recently upgraded to Access 2003.
Does anybody know a way to turn off the annoying macro security feature at startup. I can do it on a single machine by going into TOOLS, MACRO and setting the security level to low. However, I have a widely distributed front end (SQL Server back end) and it wouldn't be convenient to go around every machine.
I need some code I can write in (if possible) to do this for me - or, perhaps, somebody knows the best way to fix this problem.
Thanks
Paul
August 1, 2005 at 8:06 am
Make a xxx.reg file and copy this record:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
"SandBoxMode"=dword:00000002
[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security]
"Level"=dword:00000001
2x click on reg file update registri entry and problem with security is solved.
August 1, 2005 at 9:21 am
Thanks Dornig
This works a treat....
The only small fly in the ointment is that Microsoft Spyware tries to stop it and asks whether to Accept or Abort Registry modification.
However, this is a small price to pay.
Many thanks again
Paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply