Hi everyone,

Been a long time since I touched VB, and I'm still learning, so my code below may be scary, but I am writing what could turn into a huge project using VB and MYSQL DB. I've got them talking to each other, and actually used my program to populate some test fields yesterday. I did get an error a few times, but now I seem to get one all the time.

Run-time error '-2147217887 (80040e21)':

Multiple-step operation generated errors. Check each status value.

I click debug, it happens on a diff. line occasionally but in each of the lines above the offending line, the recordset side and the value side have the same value. On the offending line, the recordset side has a null value, but the variable 'fileloc' has a value of whatever was assigned to it.

Private Sub cmdSavefile_Click() Adodc1.Recordset.AddNew Adodc1.Recordset.Fields("fname") = txtFname.Text Adodc1.Recordset.Fields("lname") = txtLname.Text Adodc1.Recordset.Fields("email") = txtEmailaddy.Text Adodc1.Recordset.Fields("phone") = txtPhonenumber.Text Adodc1.Recordset.Fields("imagelocation") = fileloc Adodc1.Recordset.Fields("customerid") = txtBarcode.Text Adodc1.Recordset.Update txtFname.Text = "" txtLname.Text = "" txtEmailaddy.Text = "" txtPhonenumber.Text = "" txtBarcode.Text = "" imageCheck.Picture = LoadPicture

I started this email a while ago... I've done some research. My MySQL DB fname field is set to a lenght of 20 if I put in my name, Dean, it works fine. If I put in Marge with 5 letters, it errors. I figured maybe it was putting all the white space in as well and it was totalling over 20 characters... I bumped fname up to 40, and a 5 character name on up brings on the error. Any help would be greatly appreciated.

Thanks,

Dean PS I'm posting this same Q. to the VB newsserver.