Although code samples provided here are performed with Microsoft Access databases by using patterns shown they provide a upscale to moving on to Microsoft SQL-Server databases.
These patterns will go against what a novice developer believes to be the correct path for interacting with data as they are not a simple approach to working with a database. Patterns presented in the code samples are intended for both best practices along with providing reusability between forms in one project or between similar projects that work with data centric solutions.
Currently there are three articles in the series which will expand shortly to include more common solutions working with Microsoft Access databases and upscaling to SQL-Server.
In this code sample MS-Access databases are encrypted. When working with your own database and connections fail, make sure to try the following.
Also there have been reports of encryption failing with passwords longer than 14 characters.
There are a few projects marked as for answering forum questions, these were added as they may be of assistance to others.
This one is not a code sample to follow as it's fragile, only good for a single user environment.