Convert ms access to mysql using coldfusion..

[coldfused]

Ok guys this is my dilema...

I am to the point where I am just getting comfortable using coldfusion and access to do my web database stuff.

Now I found out that because of the jet engine or whatever it is in access has problems with multithreading, or multiple users online trying to retrieve the same data at the same time.

This is a high traffic site, the host says access is the reason why the database is locking up.

How hard is it to convert access to mysql, then how much different is the code for coldfusion using mysql rather than access?



---------------------------------------------

http://www.orlandomediasolutions.com

http://www.mlstaffing.com

http://www.mwll.com

 

[NorthStarDA]

you can use this software to convert if you have very little sql knowledge:

http://www.convert-in.com/acc2sql.htm

Usually, your code won't change much- depending on the complexity of the queries you are performing. I always recommend reading up on the mysql manual first though, then checking your SQL queries to make sure they are compliant- before switching your data server.