All,

When creating a custom data access class for an oleDbData Adapter, I get errors configuring the data adapter when generating the SQL UPDATE and Delete statements. The SELECT, INSERT and table mappings do not generate an error.

Basically I followed the example in the JumpStart Guide for Creating Business Objects - C# Step 6, except when creating the custom class I choose the 'oleDBDataAdapter' instead of the 'SQLDataAdapter'. I was able to select all of the columns and click the OK button to close the query builder. It was on the 'View Wizard Results' screen where the errors were detailed. Looking at the code that is generated, the UPDATE and DELETE sections are not there.

I also looked at the Northwind sample for the OrderdetailDataAccessOledb.cs file and saw that an UPDATE and DELETE section was created.

Thanks in advance fo any help offered.