"Tony Toews [MVP]" wrote:

> Matt <M***@discussions.microsoft.com> wrote:
>
> >I'm applying a digital signature to the VBA code using Access 2007 while the
> >database is still in 2003 mdb format.  The signature works as designed and
> >the database is trusted.  If I convert the mdb to an mde in Access 2007, the
> >signature is lost.
> >
> >This process worked under Access 2003 and the database would retain the
> >signature after converting it to an mde.  I'm trying to keep the database in
> >mde format to ensure backward compatability.  Any suggestions? 
>
> So why not leave the MDE in A2003 format signed and run it as is in
> A2007?
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can
> read the entire thread of messages.
>    Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

"Tony Toews [MVP]" wrote:

> Matt <M***@discussions.microsoft.com> wrote:
>
> >I would, but I've run into another problem.  My A2003 mde will not run in
> >A2007.  I believe the Access 11.0 Object Library is not automatically
> >upgrading to the Access 12.0 Object Library.  When I open the database in mdb
> >format, I have no problems and A2007 automatically upgrades the object
> >library.  In mde, it appears that it doesn't.  I'm still experimenting to
> >verify that is the exact cause for the error.
>
> Ah, that problem.  I'd forgotten about it.  Allen Browne has a page on
> that problem at his website www.allenbrowne.com but no real solutions
> I think.
>
> >For now, I'm stuck with having two different versions of the mde.  I've
> >overcome my problem with the digital signature by signing the code after it's
> >converted to A2007 mde and then running a macro to set AllowByPassKey to
> >false.  It's an extra step from my A2003 process, but it works.
>
> Good.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
>    Please respond only in the newsgroups so that others can
> read the entire thread of messages.
>    Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>