Access 2007 problems creating a signed version

[Louverril]

I have an access 2007 database which I am trying to package and sign using
the instructions from Microsoft at
http://office.microsoft.com/en-us/access/HA101980471033.ASPX

I created a self signed certificate “Louverril†as per the instructions.
Opened the copy of the accde version.
Select publish, package and sign
Select Louverril cert
Select to create in “signed packages†folder
But would not create there - only created a database under the current
folder (the one with the database in that I am trying to package and sign)
as “database.mdbâ€!

Tried signing the current development accdb copy
Same thing happened.

Tried allowing full menus nav pane and special keys
Same thing happened.

Any ideas?

Lou

 

[Arvin Meyer [MVP]]

Self certificates are only good on your own computer where you created the
database. I suggest you simply add a "Trusted Location" to your hard drive
and those of any other computers you have, and place your database there.
Then you will not need to bother with any certificates and everything should
work properly. I typically create:

C:\ CompanyName\Database\

and trust the Database folder. Other local documents are kept in the
CompanyName folder instead of the My Documents folder. That way they are my
control instead of anyone else's.

 

[Louverril]

But I want to install the database on other computers eventualy as a runtime
package so I really want to get it signed. It should work!!!

 

[Paul Shapiro]

As Arvin said, the self-signed certificates are only trusted by your own
computer. You can buy a 3rd-party code-signing certificate from one of the
certificate authorities, like Thawte, or if you're working in an
organization your organization may have its own certificate issuing
authority.

 

[Louverril]

Found the solution myself: you need to have the database you are trying to
sign on the local PC. I was trying to sign one on my file server.

Obvious really!

Lou

 

[Louverril]

Thanks Paul but this didn't really answer the question. See the solution I
found above.

Lou

 

[Arvin Meyer [MVP]]

Which is what I said, a self-cert is only good on your own computer. Again,
you are restricted to your own machine with a self certification, not the
server, or any other machine on your network, much less on anyone else's
network.

In addition to Paul's comments on a code signing certificate, be aware that
you can't change any code in the file without resigning (That includes new
queries and queries). Third-Party certificates are only good for 1 year, so
to change anything after a year, you need to buy a new one.