Trouble Deploying Access 2007 Database

[mjreiman]

I have a database put together that I'm officially ready to deploy. I go to the Microsoft Office button and hit Publish then Package and Sign. As I expected, I go the no certificate available so I click OK which should redirect me to create a certificate, but nothing happens.

 

[vbaInet]

Maybe you want to try creating an access runtime version? Try searching google for "how to deploy ms access database" and also "runtime access database".

 

[Pyro]

Alternatively you could download the MS Access Developer Extensions. Contained within that is their Package Solution wizard which includes the Access 2007 Runtime.

 

[mjreiman]

So I installed AccessRuntime and I was able to create a certificate. Now I've managed to create two with the same name and can't figure out how to delete one of them.

 

[ajetrumpet]

Alternatively you could download the MS Access Developer Extensions. Contained within that is their Package Solution wizard which includes the Access 2007 Runtime.

the package solution does not contain runtime. you need to include the file in the package, either from a local source dir or the web address provided by the packager.

 

[ajetrumpet]

So I installed AccessRuntime and I was able to create a certificate. Now I've managed to create two with the same name and can't figure out how to delete one of them.

i have never created a certificate, nor do I understand why they exist, other than verifying that the software is legitimate.

you can create very easy packaging solutions with the wizard and the ADEs microsoft provides. you should not even need runtime on your machine either. that should have nothing to do with developing and testing. it is only for computers without the JET engine already running.

I just recently wrote a FAQ on how to use the ADE wizard for 2007 if you want to take a look:

http://www.access-programmers.co.uk/forums/showthread.php?t=188226

 

[Lady Gragor]

To create a certificate:-
In Microsoft Windows, click the Start button, point to All Programs, point to Microsoft Office, point to Microsoft Office Tools, and then click Digital Certificate for VBA Projects.