Security in access 2003

[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

 

[Paul Overway]

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.

 

[dana]

The access security key don't appear in my registry keys..

-----Original Message-----
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.

--
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

.