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

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



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Rick Allison" <(E-Mail Removed)> wrote in message
news:ujA$(E-Mail Removed)...
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

--
Rick Allison
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> Have you seen the tutorial at
> http://msdn.microsoft.com/library/en.../odc_dsvba.asp
>
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Rick Allison" <(E-Mail Removed)> wrote in message
> news:ujA$(E-Mail Removed)...
> 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
>
>