How to get rid of security warning popup when opening database in Access 2003 ?

[Konrad Rotuski]

Hello everybody

in VB i use access object to call DoCmd.TransferDatabase, it is done
automatically in scheduled task
However, in Access 2003, security warning popup shows up (the one about
macros) and it cannot be done in scheduled task, as there should be someone
to click 'OK' to let it go.

The simplest solution is to set macro security level to 'Low', but it is not
really good for our clients.

i tried to run :
'msaccess.exe dbname.mdb /x my_macro'
, but this popup also shows up (although i explicitely declared i WANT to
run my macro)

another solution would be changing registry settings for Access macro
security level (have not investigated this option thus far), but it seems
also not good, as it would require additional permissions on client machine
to modify registry values

so are there any fine solutions for this ... ?

TiA

Konrad

 

[Gina]

Have you already tried setting your (under Tools)
Macro... Security... to LOW?

 

[Brendan Reynolds]

You can do this by creating an instance of the Access.Application object and
then setting the AutomationSecurity property before opening the MDB. The
Excel documentation is a little more complete on this subject than the
Access documentation - probably because the property has been around for
some time in Excel, but was new to Access in Access 2003.

http://msdn.microsoft.com/library/d...n-us/vbaxl10/html/xlproautomationsecurity.asp