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