Linda,

>I'm still having trouble saving changes to my main table. I'm getting an error "System.OleDbCommand.Prepare method requires all parameters to have an explicity set type." I haven't been able to get the custom data access class to work. I'm still suspicious that at least part of the problem is related to the code in the business object that checks for the primary key. I have a primary key assigned for an existing record. I make one change to a nullable field and then save the record. When it hits the code below in mmBusinessObject, there is a value for the primary key and RetrieveAutoIncrementPK = false. In this circumstance, the value for the variable PK will always be null, which I think will create an error, won't it? The code is listed below.

Actually, the error you're getting is related to the generation of the Update command. Does this particular table include any non-standard fields (General fields, etc)? You may want to try setting the business object's UpdateSelectStatement to see if that helps.

Best Regards,