Access 2003 - Security level - "how to" sites?

[Rick Allison]

I've done a fair amount or research on this topic and have not found any real good detailed sources. Many of the sources talk about the different level and the fact that you need a certificate from VeriSign. While I get all of that I have not seen anyplace where it says, okay you've got the certificate and a mde file here is what you need to do to distribute it.

I have written an application that I sell based on Access. I send the program as a mde and until Access 2003 all was good. Now I have to tell people to set their security level to low which is not desirable.

Any good "how to" sites?

 

[Douglas J. Steele]

Have you seen the tutorial at
http://msdn.microsoft.com/library/en-us/dnoxpta/html/odc_dsvba.asp



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I've done a fair amount or research on this topic and have not found any
real good detailed sources. Many of the sources talk about the different
level and the fact that you need a certificate from VeriSign. While I get
all of that I have not seen anyplace where it says, okay you've got the
certificate and a mde file here is what you need to do to distribute it.

I have written an application that I sell based on Access. I send the
program as a mde and until Access 2003 all was good. Now I have to tell
people to set their security level to low which is not desirable.

Any good "how to" sites?

 

[Rick Allison]

Doug,

Thanks for the link. I did read it.

I support a customer base that uses Access 2000, 2002 (xp) and now 2003. My
Access 97 base has finally all converted.

The security issue seems to apply to 2003 only. Is that true?

Is there a free certificate? Based on the reading Selfcert.exe will not
work if the program is distributed.

And, the reading talks about macros. Does this apply to VBA code too? In
my database I use an auto-start macro that calls VBA code when the database
is opened. If there is a way to run the VBA code on startup without the
macro would the need for a certificate go away?

Finally, can a function or subroutine be started on open of a file without
using a macro?

Thanks much,

Rick