I am pretty sure I can find an to convert my Access 2000 db to MySQL, but am wondering what I have to change in page code for my site.<BR><BR>Currently I don&#039t use SQL inserts, instead just do ors.addnew / ors.update / ors.delete.<BR><BR>How would I change this connection string to work with a MySQL database?<BR><BR>Set MC = Server.CreateObject("ADODB.Connection")<BR>set ors = server.createobject("adodb.recordset")<BR>MC.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="&DB&";" <BR>ors.Open "select * from tblTable;", MC, 1, 3<BR>ors.addnew<BR> ors.fields("this") = that<BR>ors.close<BR>set ors = nothing<BR>MC.close<BR>MC = nothing<BR><BR><BR>Would I just change:<BR><BR>MC.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="&DB&";" <BR><BR>(and to what)?<BR><BR>Thanks a lot.. was just informed that site was being moved to a linux server with chilisoft and they weren&#039t going to install access component. Evil server.