Access Solutions

11 Tips for Making an Access Application Ready For Distribution

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

Read more »

How to Deal with Dead Code and Hassles like Unused Variables in MS Access

In this article we look at negotiating dead code and unused variables in MS Access with an eye on improving performance. In an Access application, there is a lot that needs to be taken into account to make sure that the application not only works efficiently, but is also fit for sharing, and working well for everyone in the workgroup. You need to pay attention to each and every aspect of your access application, ranging from Forms, Reports, Tables, to Modules and a lot more. And each of...

Read more »

How to Release Resources Taken by an Automation Object in MS Access

In this article we look at how resources occupied by an automation object in MS Access can be released The process of Automation allows applications to expose objects. This is done by making use of the application’s properties and methods, which can in-turn be used by other applications for creating an instance, as well as controlling it through codes. Automation is increasingly being used by several applications, instead of Dynamic Data Exchange. All application in MS Office Suite...

Read more »