O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12.4. Distributing Your Application

Now that you have tested and optimized your application, you are ready to compile and distribute the application to end users. You have various distribution options, such as distributing the database to users with the full-blown version of Access, distributing the application using the Access runtime, and distributing ACCDE files. Each of these will now be discussed.

Before distributing your application, you should first compile the application. You do not want end users dealing with compiler errors that could have been avoided by compiling prior to deployment. Compiling will also help the application run faster. One way to compile an application is from the Visual Basic Editor, by selecting the Debug Compile DatabaseName option.

12.4.1. Distributing the Application to Users with the Full Version of Access

In some cases, you may be distributing the application to users who already have the full version of Access installed. Other than making the ACCDB file(s) accessible to each user, you do not have to take any other steps in order to deploy the application to those users.

12.4.2. Distributing the Application with the Access Runtime

If you have end users who do not have Access installed, you can distribute the application to them using the Access runtime. The runtime is a limited feature version of Access that has the following limitations: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required