Grig,
PMFJI but why a single quote (if I saw it right) is an invalid SQL char? Probably original code was doing it right in the first place.
Cetin
>Thank you so much, Bonnie
>
>Eventually, that's what I did. Unfortunatelly, when customer saw half of his application needs to be thrown away said "ok, i was hoping we'll fix it doing small changes here and there, but it looks in not possible, that's why we'll stop".
>
>:) Thank you anyway,
>Grig.
>
>>Hey Grig,
>>
>>
>I didn't design the application and there is no table. <>>
>>No table? Odd. Then why did you have a table in your .Update() statement? Well, never mind, the solution is simple. Don't use .Update(), don't even use the DataAdapter. Try this (untested code, watch for typos):
>>
>>OleDbCommand command = new OleDbCommand("Insert into table (field1, field2) Values (@par1, @par2)", MyConnection);
>>command.Parameters.Add("@par1","value1")
>>command.Parameters.Add("@par2","value2")
>>command.ExecuteNonQuery();
>>
>>
>>~~Bonnie