Hi,
i want to know what code can i place in my program in order to bypass the security notice it appears on the screen each time access opens it?

are you talking about the macro security?

Kevin

dartcoach

yes, i guess is macro security.

The problem with Macro Security is that it is tied to the actual installation of Access and cannot be controlled through a database. The idea is to protect your computer from a maliciously coded database.

If you would like to disable this on your computer, just go to Tools - Macros - > Macro Security and then set the security to Low.

If you do this, you just want to make sure you don't open databases sent to you from unknown people.

Mike
EchoVue.com

Access 2002/2003 has 'Macro Security' and installs in what is called 'Sandbox Mode' with additional securities against potentially harmful code. First you are directed to upgrade to the Jet database engine and then you get the generic 'unsafe expressions' message.

Mike from Echovue is right that you can disable the message by lowering the security setting, but if you are opening databases from other people/companies and you are not sure whether these are secure databases that may be your best option.

If you are opening your own databases as well, you can create a 'self-certification' digital signature so the messages are not opened when you open your own databases but maintain security when opening others. Chapter 20 in "Access 2003 VBA" by wrox covers the options in great detail.

Also there is an article in the Microsoft Knowledge Base (Q294698) that gives more information about the sandbox mode.

I hope this helps,
Bryan

WhoFan, nice post on sandbox mode. Clicking all the right warning buttons takes you out of that mode.

I didn't know about self certification. I have the book and will look it up. Is that transportable within the organization? Or will that require a formal certification process (if I send the app down the hall, does it work the same as on my PC?)

Thanks,

mmcdonal