moving access data to mysql

I just moved my database from MSACCESS to MySql using the migration tool at http://www.mysql.com/products/tools/ . I works pretty good and are free. The queries are about the same.

ok, i have installed mysql and just followed the manual to create a test database called pets....I have no idea of how to get this database from mysql onto my webserver.
With MS access i just save the file in the db folder, and then add the datasource to the coldfusion DSN feature of my web server.....I have no idea of the system for achieving this with mysql...i have googled this and got no response, and my web hosts support centre havent been helpful here...
Is there a book, you can recommend or website for this sort of thing...
cheers

im gonna have a go at this today and see what happens, hopefully its not too daunting

cheers

If you have the necessary odbc driver installed, you can use Access as a front end for lot's lot's of other databases. They call them linked tables. However, sometimes Access "optimizes" your sql for you, so pay attention to what's happening.

...i did read of some system however, that allows you to retain the access frontend, and then all your data is held in mysql in the backend, that would be helpful

changing all code would take a lot of time, but if it has to be done it has to be done, hopefully there arent that many differences between the systems..
also i understand that the latest version of access if bigger than previous versions, I wonder if it is now more capable of dealing with larger amounts of information

I don't know if it's difficult, but I know that the s in sql stands for structured, not standard. That means mySql and Access have different syntax in some situations. They also have different function names. This means you are going to have to test and possibly rewrite every query. The sooner you make your switch, the fewer queries you will have to test.