Keeping the peace between Microsoft Access and MySQL

Well the boss asked me to write up a short blog relating to an issue we had recently. It’s my first one since I joined Gravity Computing so hopefully its not the last.

The issue came about whilst working on a project for a client. The project used Microsoft Access as a frontend for an application with a MySQL database backend. The database tables were linked using the ODBC driver version 5.2 into Access from MySQL and data-bound forms were used to interact with the data. More →