I hate MS Access and especially developing with it as you can’t do any thing clever with it. Wrong, Wrong, Wrong! There are a few clever things I have been able to script to make developing with it passable. I still would rather use Visual Studio but this improves the experience a fair bit. Source Control Access files...

I spend an awful lot of my working life adding new features and improvements to a legacy database system. A legacy system is an old method, technology, computer system, or application program, “of, relating to, or being a previous or outdated computer system.” Often a pejorative term, referencing a system as “legacy”...

For historical reasons I use Microsoft Access as the front-end for all my line of business databases. Access allows you to create an ADP file that can connect to your SQL Server database. However Office has dropped support for this, so the last version of office that I can use is Office 2010. Before I start hating on...

Today I encountered a new error. Run-time error ‘6’: Overflow doesn’t really tell me much. The error was occurring in the Access ADP front-end of our main database. It was only occurring for one particular Id number which was really confusing me. First thing I tried was to remove the most recent changes I had made,...