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.
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.
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: ...