How to programmatically disable the "Security Warning" screen?

[accesser]

How can I, by using the VBA, disable the "Security Warning" screen which appears one I open the MDB file??

Please advise.

Thanks,

 

[Dairy Farmer]

If it is 2003 (guess by MDB extension) the edit the registry:

HKLM\Software\Microsoft\Office\11.0\Access\Security
"Level"=dword:00000001

 

[Galaxiom]

It is better to digitally sign the code than to turn off security like that. The security question is then only asked once and then all code with that signature is trusted.

 

[accesser]

How can I digitally sign the code that turn off security??

Please advise.

Thanks,

 

[boblarson]

How can I digitally sign the code that turn off security??

Please advise.

Thanks,

see here for how to digitally sign the project.

 

[Karen831]

Thanks - that worked great!