Linking Access to a MySQL database
Saturday, May 27th, 2006For some time I was using Access to store and manage some simple data for a web site. Unfortunately, due to a change in hosting provider I was not able to continue using the Access database and had to migrate it to MySQL. One thing I wanted was to keep the Access forms I’d created for updating the data in the database and to create an external link in Access to the MySQL database through MyODBC. Creating the external link wasn’t a problem but there were a few gotchas that I discovered along the way to getting the forms working correctly.