Access 2003 - Security and Warning

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have front end in many computers, so I didn’t like to go one by one to
change the level security to Low.
So, how can turn off this message programmatically? Is it possible?

Thanks
José
 
Jose,

Unless you have signed the code using a digital certificate, then no, you
can't. It's a "feature".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
if to turn off the security and warning is need digital certificate, I would
like to know how can I do.
Could you help me?
Thanks
jose
 
Hello José,

I have not created a certificate before for Access 2003 so I cannot be of much direct help. However,
here is a bunch of information and links on the subject that I have collected. These should get you
going. Watch out for any possible line wrapping on these links!!


If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at:
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see:
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings:
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033

More info here:
How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003
http://support.microsoft.com/default.aspx?kbid=294698

Still more info here:
http://www.fmsinc.com/free/tips.html#accesstip19

Another link on the subject:
http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

An online course:
http://office.microsoft.com/training/training.aspx?AssetID=RC011461801033


This was a recent post by a poster named TC:
Begin Quote>>>>

IMO the best way is to start the database via a script file which sets
the macro security level to low for that single invocation of Access.
This does not require a certificate, or a registry change, and it does
not affect any other database(s) - just the one being started by that
script.

Eg. in VBScript:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.usercontrol=true
set o=nothing

TC
End Quote>>>>


Here is a post by Microsoft employee Eric Butts:
Begin Quote>>>>

Within the Microsoft Access help topic "Digital Signature" it details how
to sign your database.

Regards,

Eric Butts
Microsoft Access Support
End Quote>>>>


And here are some more links provided by Tom Wickerath:

Create your own digital certificate:
http://office.microsoft.com/en-us/assistance/HP052495581033.aspx

Signing Access 2003 Projects:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart04/html/sa04d1.asp

Code Signing Office XP Visual Basic for Applications Macro Projects:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_dsvba.asp

MS Office 2K macro security:
http://msdn.microsoft.com/library/d.../en-us/odeopg/html/deovrsigningvbaproject.asp


That should get you going.
:-)
 
Back
Top