Syntax error in INSERT INTO statement

Hi,

This is starting to really do my head in. I have an Access db set up and I am trying to insert data into it via a HTML form.
Can anyone tell me what is wrong with the following lines?

mySQL = "INSERT INTO bud (desc,vendor,contact,quantity,cost,dep,bal,due)"
mySQL = mySQL & "VALUES ('" & request.form("desc") & "','" & request.form("ven") & "','" & request.form("con") & "','" & request.form("qua") & "','" & request.form("cost") & "','" & request.form("dep") & "','" & request.form("bal") & "','" & request.form("due") & "')"
conn.execute(mySQL)

Similar code works fine on another page entering into a different table within the same databse.

Any advice would be greatly appreciated.
Paul.

change the column desc to another name

Thanks for your reply, could you advise on how to change the field names within Access, as it appears if it is done either in Design view or Datasheet view it only changes the 'shortcut' name and not the actual field name, a bit frustrating that!

I have even deleted a whole table within Access but can still connect to and read data from it with ASP!

Thank you
Paul.

Thanks... even i had the same problem & solved it.