How to create setup for MS ACCESS application?

[Malathi]

Hi,

Ive an Access application(VBA application) which uses sql and access itself as backend and has forms,reports, etc. Now I want to create the setup for this app. How to create in access? Using .net Package and deployment wizard can I do that? Or any other way? Any help is appreciated!

Thanks in Advance,
Malathi

[twinnyfo]

Malathi,

What do you mean by "create the setup" for your Access application? You can make a project out of it by making the .accde file, but I'm not sure of your question. Please clarity..

Thank you.

[Malathi]

Hi twinnyfo,

Thanks for replying. To install any software such as MS office, MS Visual studio, we get installation setup. If we double click on the setup it will install the software by asking some questions thru some pop up windows(like at what place we have to install, do we need shortcuts to open the app, etc). So I want like that. I would like to make my MSAccess project into setup. So that users can see the frontend only. Please share your ideas if you have any.

Thanks,
Malathi

[john garvey]

Hi Malathi

I think what you need is this 'Access package and deployment wizard' If that is so then search Microft web site for the developers extensions

[ariful alam]

Access 2007 has an option "Package and Sign" in Office Logo -> Publish. You have to use that to create a setup program. but to this you must have to create a certificate first from Start-> Programs-> Microsoft Office-> Microsoft Office Tools-> Digital Certificate for VBA Project. Because "Package and Sign" needs a digital certificate to create a package.

Moreover Access 2010 may has a .exe setup option also.

[john garvey]

Hi

If the developers extensions are installed you will get a further option on the access button titled ->Developer.

When clicked it provides the following extra functions
1. Package Solution
2. Save as template
3. Create from sourceSafe

The package solution wizard will guide you through the process