Access 2003 security question

[Marco Castro]

Every time that I open up my access database I get a message saying that its
using macros and then asks me if I want to open it. I don't really want to
get rid of this for any new databases that I open but is there any way that
I can add this one to some kind of safe list so that access doesn't keep on
asking me if I really want to open this database every time?

 

[Bill James]

If it is your database, you can now (Access 2003)
digitally sign your VBA project.

Create or obtain a digital certificate and use it to
digitally sign your VBA project. Then add the
certificate to the Trusted Publishers certificate store.

Then I recommend setting your macro security to "High"--
only digitally signed macros from trusted publishers will
be allowed to run.

 

[Marco Castro]

That did the trick, thanks for your help.

If it is your database, you can now (Access 2003)
digitally sign your VBA project.

Create or obtain a digital certificate and use it to
digitally sign your VBA project. Then add the
certificate to the Trusted Publishers certificate store.

Then I recommend setting your macro security to "High"--
only digitally signed macros from trusted publishers will
be allowed to run.