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 these aspects have their own specific problems that you as a developer might have to deal with. Don’t let this freak you out, but instead inform you about what all you need to know, and take care of, before you begin distributing your application.
Although there are several problems you may encounter, today we will be focusing on just one of them: which is none other than the problem of dead codes and unused variables. How will you feel if an unused, redundant item has been lying in front of you from very long time? It can either be at you home, in office, or both. This comes to your notice every day, but you can never get the time to get rid of it, that too when you know it is occupying some precious space which can be put to better use if you get rid of this! A very similar phenomenon works with dead codes and unused variables as well.
What are Dead Codes and Unused Variables and why should you get rid of them?
As explained in the example mentioned above, dead codes and unused variables are unwanted, and redundant codes and variables which are of no use anymore for your application. These are only taking up precious space on your system, and giving no benefits. If they are removed, you could make use of that space for storing new, advanced, and usable codes and variables.
It is important to get rid of these dead codes and unused variables, not only because they are occupying crucial space but also because they are obstructing the performance of your application. Once you get rid of them you will get more space in your application and also experience improved compilation of code during runtime. Getting rid of them is one of the most important thing you need to do before you distribute your application. No one would like working on an application which continues to have codes which are no longer used. This will not only spoil your reputation, but will also put your efforts in question. They can further lead to errors which would require a tool to repair the corrupted Access database.
How to get rid of them?
This is not something that is very challenging or something that will take too long to get done, this is in-fact one of the easiest steps that you will have to take before distributing your application. However one of the key things to keep in mind is, you do not just have to delete dead codes, but also the remaining unused variables, which is something that is often forgotten. To get rid of dead codes and unused variables, you simply need to delete them, and then replace them with new codes, which can be put to use, and simplify working on the application.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql fix and excel recovery software products. For more information visit www.datanumen.com