Access 2007 problems creating a signed version

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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