MS Access: upsizing to SQL Server 2008

I’m currently researching ways to move my main MS Access application from a simple local network client/backend setup to a global, multiple remote sites configuration using SQL Server. One of the challenges is to upsize the current MS Access accdb backend database to SQL Server 2008. If you try it from Access itself using the... » read more

.Net: Working with OpenOffice 3

(__Updated Wednesday 30JAN2009.__) Developing applications that manipulate OpenOffice documents has always been rather tricky; not very difficult, but just tricky to get right. With OpenOffice 3, things got trickier and applications that used to work will now fail. I’ve just spend nearly a day trying to get a mail-merge application I built to work again... » read more

Linux: AutoCAD DWG to SVG preview conversion.

Years ago I did a [small utility][cad2svg] to convert [DWG][DWG] or [DXF][DXF] files into a vector-graphic, zoomable, [SVG][SVG] preview. The Linux command-line utility was used in a larger drawing management application that I had built before I left that company for greener pastures. The Linux server-based application would scan the vast (100,000s of [CAD drawings][CAD])... » read more

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