Access Database Recovery

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 »

How to Work With Snaking Columns in MS Access

Snaking columns is a popular feature is MS Access which is routinely used by advanced users. Snaking columns in MS Access can be found in Access reports and help in consuming all the left over space on the page, thus leading to fewer prints and faster processes. We often need to print some text which can be easily accommodated in less than half or simply half the page. In such a situation, you can make use of snaking columns and make full use of the space on your page. When using snaking...

Read more »