Defensive Programming - No Longer Set

In Defense of Security Through Obscurity

There are two key elements to defending a military position: cover AND concealment. It's not an either-or proposition.

A quick tip to ensure your temporary code disappears when the sun sets.

Let's apply the concept of frictionless development to the defensive programming technique of data validity checks.

Increase the quality of your existing data by running it through a series of validity checks and showing your users the results.

Identify the critical functions in your application. Then, apply one or more of these techniques to ensure that if they break, someone will notice.

Software Developers Can Almost Eliminate Logic Errors With This Powerful Technique

As developers, we need to constantly be thinking about how to handle unknown unknowns. The RecordsAffected property helps us do that.

If you are just starting out writing VBA in Microsoft Access, you may be tempted to use DoCmd.RunSQL. Don't. There is a better way.

This simple technique is a foolproof way to avoid the sort of logic bug that can live undetected in your codebase for years.