Security in access 2003

  • Thread starter Thread starter dana
  • Start date Start date
D

dana

Hi

when i open an mdb file, it gives me an error
asking "microsoft jet 4.0 service pack 8"
i solved this problem by updating the security level to
low.
i want to prevent the users from doing that by
themselves, is there a script i can run for them that
will do that? (set their security level to low)

Thanks
 
You'll only get that warning if SP 8 is not installed....you should install
it. Nevertheless, you'll still get a macro warning if your MDB had anything
in it, and the only way to overcome that is to set the registry keys when
your app is installed or digitally sign your code. The registry keys are:

[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

Note...the user could change the setting back to medium or high though.
 
The access security key don't appear in my registry keys..


-----Original Message-----
You'll only get that warning if SP 8 is not
Click to expand...
installed....you should install
it. Nevertheless, you'll still get a macro warning if your MDB had anything
in it, and the only way to overcome that is to set the registry keys when
your app is installed or digitally sign your code. The registry keys are:

[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

Note...the user could change the setting back to medium or high though.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


Hi

when i open an mdb file, it gives me an error
asking "microsoft jet 4.0 service pack 8"
i solved this problem by updating the security level to
low.
i want to prevent the users from doing that by
themselves, is there a script i can run for them that
will do that? (set their security level to low)

Thanks
Click to expand...


.
Click to expand...
 
Back
Top