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/ac...980471033.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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Louverril" <(E-Mail Removed)> wrote in message
news:576AA929-FC1A-4055-8C23-(E-Mail Removed)...
>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/ac...980471033.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

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

"Arvin Meyer [MVP]" wrote:

> 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.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "Louverril" <(E-Mail Removed)> wrote in message
> news:576AA929-FC1A-4055-8C23-(E-Mail Removed)...
> >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/ac...980471033.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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:5765E370-B6F9-45F7-BD0E-(E-Mail Removed)...
> 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!!!
>
> "Arvin Meyer [MVP]" wrote:
>
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> "Louverril" <(E-Mail Removed)> wrote in message
>> news:576AA929-FC1A-4055-8C23-(E-Mail Removed)...
>> >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/ac...980471033.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.

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" wrote:

> 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/ac...980471033.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

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

Lou

"Paul Shapiro" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:5765E370-B6F9-45F7-BD0E-(E-Mail Removed)...
> > 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!!!
> >
> > "Arvin Meyer [MVP]" wrote:
> >
> >> 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.
> >> --
> >> Arvin Meyer, MCP, MVP
> >> http://www.datastrat.com
> >> http://www.mvps.org/access
> >> http://www.accessmvp.com
> >>
> >> "Louverril" <(E-Mail Removed)> wrote in message
> >> news:576AA929-FC1A-4055-8C23-(E-Mail Removed)...
> >> >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/ac...980471033.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.
>
>

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Louverril" <(E-Mail Removed)> wrote in message
news:7BD808B4-FC8D-4647-A8BA-(E-Mail Removed)...
> 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" wrote:
>
>> 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/ac...980471033.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