Access 2007 problems creating a signed version

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louverril - 14 Jan 2008 17:13 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 14 Jan 2008 18:17 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have an access 2007 database which I am trying to package and sign using
> the instructions from Microsoft at
[quoted text clipped - 19 lines]
>
> Lou

Reply to this Message

Louverril - 15 Jan 2008 12:47 GMT

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!!!

> 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
[quoted text clipped - 30 lines]
> >
> > Lou

Reply to this Message

Paul Shapiro - 15 Jan 2008 13:06 GMT

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.

> But I want to install the database on other computers eventualy as a
> runtime
[quoted text clipped - 36 lines]
>> > Tried allowing full menus nav pane and special keys
>> > Same thing happened.

Reply to this Message

Louverril - 15 Jan 2008 13:19 GMT

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

Lou

> 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
[quoted text clipped - 42 lines]
> >> > Tried allowing full menus nav pane and special keys
> >> > Same thing happened.

Reply to this Message

Louverril - 15 Jan 2008 13:17 GMT

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

> I have an access 2007 database which I am trying to package and sign using
> the instructions from Microsoft at
[quoted text clipped - 18 lines]
>
> Lou

Reply to this Message

Arvin Meyer [MVP] - 15 Jan 2008 20:17 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> 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.
[quoted text clipped - 27 lines]
>>
>> Lou

Reply to this Message