Digital Signature lost when converting to MDE in Access 2007

[Matt]

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?

Matt

 

[Tony Toews [MVP]]

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/

 

[Matt]

Tony,

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.

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.

Thanks,

Matt

 

[Tony Toews [MVP]]

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/

 

[Matt]

O.K. I'll take a look at their site.

Thanks for all the help,

Matt