In this article we look at several steps that one needs to take in order to make an MS Access application ready for deployment.
It rarely happens that you get the liberty of developing an Access application solely for your use, because more than often you need to share it and distribute it among other users. And when you are done developing the application for distribution, you can simply make use of multiple workstations to ease the process of distribution. However, before you begin distributing you Access application, there are a lot of things that you need to take care of; these will help you build an application with minimum flaws. As creating an Access application which has no flaws whatsoever, is not possible, you can make use of some tips to create one with minimum flaws. Read the tips below thoroughly to avoid problems in your Access application.
- If you set the option of Current Database, you can save yourself the time and energy that would go into getting the code to perform all the necessary functions, along with providing you the control of the interface of the application from the moment it was launched. Make sure the Current Databases options have been verified before the process of distribution begins.
- Before you distribute the application, add a name/ title to it, in-case you miss out on this, the title bar will show the name of the database along with the word “Access”.
- Small bitmaps can be created using Windows Paint, to convert these .bmp files to .ico files, you can make use of a conversion tool. Icons can be searched using graphic programs, or online.
- For your start up display form, you can consider using a ‘Splash screen’.
- The ‘Status bar’ is not just an easy to use tool, but also a very informative one, as it can give you insights into the key states. Therefore enabling it; instead of disabling it should be your priority.
- When you are distributing your application, it is advisable to un-check Access special keys checkbox. This can avoid the circumventing of options selected by you, by preventing the users from doing the same. This will thus avoid the disclosure of Navigation Pane as well as VBA code edition, which could lead to confusion with more problems.
- Till you have not de-selected the ‘Access special keys’ option, users will be able to un-hide Navigation pane by simply pressing F11.
- Name AutoCorrect option is one of those options which is turned on by default in all the Access applications. If you believe this is helping you, you can let it be, otherwise turning it off before distribution might be helpful.
- The objects like ‘Hidden objects’ and ‘System objects’ which you do not wish to modify anytime soon, are better off if hidden. You do not have to make them visible, if you do not want them to undergo any changes.
- Layout view can be disabled for individual objects as well, so even if the option is enabled there is still scope for not being able to see the layout of a few forms and reports.
- Last but not the least check for data errors and keep a tool to deal with Access corruption handy
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including fix sql and excel recovery software products. For more information visit www.datanumen.com