In this article we look at debugging goals that one needs to keep in mind while developing applications in MS Access and understand the rationale behind these goals.
Developing an application entails forming a code, implementing it, knowing the errors, fixing them, and then trying the modified code. The development cycle of an application is a lengthy process, to make this process quicker, a developer uses debugging. Debugging quickly pinpoints the problems in your code, helps you address them and makes your development cycle a little longer. As the codes you develop become more complicated, debugging becomes more important. It is one of the most important skills for a developer. There might be instances where a developer might miss out on the key debugging goals, while building an application. So here are all the important debugging goals that a developer should keep in mind while developing an application.
- Fixing Bugs – Whenever you run a code and encounter a crash, you should always use debugging for diagnosing the code and fixing errors. Apart from debugging, you will also need to have efficient error handling in place, to be able to deal with any kind of crashes in the application. If you are not running the application in MDE, you can open the IDE, by clicking on Debug to examine and solve the problem.
- Analysis During Development – Debugging should not only be used to spot the error but also to check if there is no error. While setting up the application the developer must run the debugger to ensure that code runs smoothly with no error. There are multiple debugger options available for the developer to choose from, the Access debugger allows you to go through each line of your code, while examining the environment and also makes necessary changes in variable values and lines in the code. Once you see your code running, you will be able to get a better understanding of how it will perform, and does it perform the way it was meant to perform?
- Supporting Deployed Applications – By making use of a central, consistent error handler, a developer can document all the crashes that occur in the system, by deploying certain applications. This is important in-case of multiple customers, when the developer can’t go to all offending desktops. With the help of a sophisticated error handler, a developer can not only document the error, but other important details as well. Like – name of procedure, procedure call stack, site of crash, and other information about Access environment. This information will not only allow you to reproduce errors quickly, but also ensure necessary fixes for the encountered errors.
Key Points to Remember
Debugging is a skill/ process used by developers for quickly spotting the errors in the software code that the user may face. Debugging allows the developer to not only spot, but also fix the encountered errors, and cut – short on the development cycle of an application. A developer should keep in mind the above mentioned goals to be achieved while debugging, so that the resulting application is free of errors and crashes. Despite your best efforts, the Access application you have created or the underlying data file may become corrupted. To avoid any possibility of data loss, always keep an mdb recovery or accdb recovery application handy.
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