Access > SQL issues

[mmltonge]

Hey, i recently transferred to a new host, on my old host i was using Microsoft Access with my .asp site. I found out once i paid for the new host that they dont support access and that i will need to convert to MySQL. Are there any full free programs to do this? (cant afford, wouldnt be cost effective to pay for one) and how much of my .asp code will need to be changed? will all the adding/edit/deleting commands still be the same in .asp or not?
Thanks
Mark

[sijpie]

The changes aren't drastic. No MySql expert myself, though, there will be a number of changes. First the sql code is ever so slightly different, not for normal selects or inserts, but for inner and outer joins (called left and right joins in access), and also for setting up the tables and fields, etc.

The other difference is in getting connected to the database.

Best to go to the mysql website, and get onto a tutorial there to get yourself started.

Depending on how much sql code you have, it could amount to a fair bit of work. On the upside, if you have a large database and or complicated queries, you should notice a significant faster response from MySql.

[mmltonge]

i changed over successfully (after about 25 emails with the host setting up new DSN's for the converted databases) all that i needed to change was the connection line and the LIMIT line, in access it is SELECT TOP 3 * FROM where as in SQL it is SELECT * FROM TABLE LIMIT 5 etc. Went well, it is faster, much faster. Thanks for help