Warning message...

[KenHigg]

Anyone know how to suppress the folowing warning:

(I don't have admin rights so my solution will have to be done within Access )

 

[ghudson]

The user has to set the Access macro security level to low for their computer.

It can not be done with VBA. But you can run a registry key to do it.

This will work even if you do not have admin rights to the PC.

This command will alter the registry and set the Access macro security to LOW for all users of the PC.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Security]
"Level"=dword:00000001

Copy and save that code into a text file but give the file a .reg extension. Then you can launch [double click] the file to update your PCs registry.

You can silently launch the file by calling the .reg file like this...

Call Shell("REGEDIT /S \\Server\Partition\Directory\YourRegFile.reg")

...and the user will not receive the warning "are you sure you want to add the information to your registry".

Any novices reading this post... backup your PCs registry before you attempt to alter it.

 

[Pat Hartman]

You also need to make sure that you have the latest version of Jet because there are some security messages involving sandbox mode also. Jet can be downloaded from the Microsoft download site.

 

[ghudson]

This will take care of the SandBox mode [registry key] for Windows XP and Access 2003 [once you have the latest version of Jet]...

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
"SystemDB"="system.mdb"
"CompactByPKey"=dword:00000001
"PrevFormatCompactWithUNICODECompression"=dword:00000001
"SandBoxMode"=dword:00000002