hi I have been using dreamweaver mx with access as the database but want to try mysql now is it possible to connect my site which is all asp pages to if so how ? and is it worth all the effort ?

yes, all you have to do is create the DB in mySQL, import your data, and change the connection string for your recordsets...

yes it is worth it if your pages/apps get any amount of traffic...Access is not server software (ie it is not particularly suited for multiple simultaneous connections) whereas mySQL is.

Best of all, you get the abilities of MS SQL Server for FREE.

Check it out, you'll be glad you did.

Doc
Rangewalk Digital Studios

<i>Best of all, you get the abilities of MS SQL Server for FREE.</i> - Well, not quite, try building a sub-query in MySQL <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

ok thanks i will give it a try