Hello,
I would like to use an asp application in MySQL that was origionally set up for access db. Connection is fine and pages work good with data already entered but i does not add data through the forms... i do not get any errors. i'm not very farmiliar with MySQL. do i need to add something to the db to get this to work? any help would be great...

UserUpdate()

Function UserUpdate()
On Error Resume Next

Set rsUser = Server.CreateObject("ADODB.Recordset")
rsUser.open "users", conn, 3, 3
rsUser.AddNew
rsUser("username") = username
rsUser("password") = password
rsUser("firstname") = firstname
rsUser("surname") = surname
rsUser("email") = email
rsUser("dob") = dob
rsUser("starsign") = starsign
rsUser("sex") = sex
rsUser("icon") = icon
rsUser("sendemail") = sendemail
rsUser.Update

Why dont you just import it into MSSQL... It would be much easier... and it would be faster, because ASP plays well w/ MSSQL

But yea.. That is what you should do if you can.

ahh i scrapped that idea... the application is great but just too many issues with .asp and MySQL for me.