MS Access: checking network paths without freezing your application

Access programming is inherently single-threaded. That’s usually OK as most operations are sequential anyway and it keeps things simple at the programming level. There are times though where the lack of ability to run code on another thread is sorely missing: anything that takes a long time to run will just freeze the application, making... » read more

MS Access: Enhanced Message Box Replacement

This project provides a custom and enhanced message box replacement for the default `MsgBox`found in Access. A Test database containing all the code for Access 2007/2010/2013 is available at the bottom of this post. (__UPDATED Saturday 21OCT2014 to VERSION 1.10.__) ###What’s wrong with the default MsgBox### The default message box in Access is sometimes useful... » read more

MS Access: Restarting and compacting the database programmatically

In my previous article about changing the MS Access colour scheme I had the need to allow the user to restart the database after the colour scheme was changed. (__Article and Code Updated 13FEB2009.__) Being able to cleanly restart and compact the application is also useful in other instances: * Changes made to the environment... » read more

MS Access: Changing the Color Scheme programmatically

Microsoft Office 2007/2010 comes with 3 colour (color) schemes. Users can easily change it but when you deploy an Access application under the [Runtime][runtime] your users have no way to set the colour scheme as the application’s options are not available. (__Article and Code Updated 01DEC2014.__) Luckily for us, the global colour scheme setting in... » read more