Porting tables from an application written on top of MS Access Appliction to MySQL
===

My brother uses an application called Kennel Connection - http://www.kennelconnection.com/screen.html that has a Microsoft Access backend.

He wants me to create come reports and display them on a webpage.  I know some PHP but freely(well maybe not freely) admit that I use dreamweaver as a crutch to speed along my php development.  Most of my experience in PHP is based on a mysql backend.  

The database has about 20 tables though only about 5 are used on a regular basis.  Is there any reason I couldn't import those 5 tables in to mysql and create linked tables inside the application pointing to those mysql tables?  In the short term I would just port the key tables with the longer term goal of porting all the tables to mysql? 

My biggest concern would be related not knowing if the application would have any hiccups writing to a linked mysql table rather then an internal access table.  Anyone have an experience with this?

