Hi

I have created a strongly typed dataset in VB.Net. I can sucessfully fill the OLEDBDataAdapter and display the contents of the data adapter.

I can successfully create a new row, and insert it into the dataset. However, when I try to commit the changes to the Access database, I get a blank error exception.

When I use Try and Catch with the update command I get the follwing error message,

"Syntax Error in INSERT INTO Statement".

I created the dataset, by creating a component which housed the dataset within it, using the component designer. The dataset and all the commands were generated from the designer. I actually entered no code.

Is there something I am missing, or is there a bug in the OLEDBDataAdapter in .NET component designer?