Running an Access Database on your Phone

As the world becomes more mobile and cloud orientated, I have been working hard trying to get a database to run on a smart phone in some form. Ultimately I’d like to host a database in the cloud and then be able to use Access as an interface not only on a desktop PC...

Using Cloud Services from Access and VBA

I’ve been developing database solutions using Azure SQL as a cloud-based database for a few years now. The combination of the local functionality afforded by Access coupled with the ability to share data across the internet has proved very powerful. Recently I have...

Keeping it Neat

If I had to come up with a single phrase to describe the myriad of spreadsheets and databases that I’ve encountered over the years it would be – ‘If it looks terrible, chances are that it is.’ I’ve been working with spreadsheets, databases and Visual Basic code...

Two Keys in a Successful Project

Over the years I’ve been involved in loads of projects and I’ve noticed that there are two key factors that every successful project shares. They seem obvious but it’s surprising how often they’re lacking. At the outset of a project, especially a long and/or complex...