By: Garry Robinson
(By Ian Andrew from Canberra with a little bit of help from Garry Robinson.)
Setting the Scene
Last year we took on an elderly, undocumented Access 97 database linked to a MySQL back-end. The task was to fix existing problems, upgrade to Access 2007 and Vista, and bring the functionality in line with current business practices. It would involve an independent re-build (mainly off site) so that existing operations could continue unhindered.
Concurrent upgrading changes weren’t ideal: when a problem arose, we had to work out whether it was due to a flaw in the original database, or 97 to 2007 differences, or some aspect of the Access to ODBC driver to MySQL linkage. But we had no choice and with Allen Browne’s comprehensive list of Access 2007 issues, we marched on.
Continue reading "MS Access and MySQL"
