I've tried doing a search for a solution, but to no avail.

I have a simple insert statement that should write to an Access database. It's only one table and all the datatypes are text.

VB Code:
  1. CN.Execute "INSERT INTO Part_Info ( ID, Man, Cur, Desc )" & _

  2.             "Values('" & arrAdd(0) & "', '" & arrAdd(1) & "', '" & arrAdd(2) & "', '" & arrAdd(3) & "')"

I copied my code from another project exactly and simply changed all the names of the variables.

For some reason it will not take all of these values and says there is something wrong with my insert statement. If I take out the last 2 it works. If I insert the PK (the ID field) and then do an update, I can get the update to work for Man and Cur, but I have to update them seperately. This is driving me absolutely mad. Please help me.