Add the following, before creating the CommandBuilder to fetch the primary key information:

m_DataAdapter.FillSchema(m_DataSet,SchemaType.Source,"customer");

>Nope :(
>after the following line executed the error below was thrown.
>
>m_DataAdapter.UpdateCommand = m_CommandBuilder.GetUpdateCommand();
>
>// Additional information: Dynamic SQL generation for the UpdateCommand is not
>// supported against a SelectCommand that does not return any key column information.
>
>
>I am still thinking this as a problem because of the database type. A DBF even with an attached CDX doesn't have a primary key. CDX's contain collating sequences, but nothing that could cause the recordset to get rolled back accurately. I should have to specify which index tag in the CDX is unique or uniquest.
>
>
>Appriciate the help,
>Mike