Stuart,

>when I set the this.RetrieveAutoIncrementPK = true , it crashes at this point in the code.
>
>

>this.RowsUpdatedOnSave = dao.SaveDataSet(ds,
>tableName,
>PK,
>RetrieveAutoIncrement,
>dbAdapter);
>

>
>with the error
>

>When MySqlCommandBuilder.ReturnGeneratedIdentifiers is true,
>MySqlCommand.UpdatedRowSource must be set to None.
>
>

>
>This is connecting to MySql

I'm thinking you probably have to override the mySQL data access class's ConfigureInsertForAutoIncrement() method. If you have subclassed from mmDataAccessSQL, it contains code that appends the followingto the Insert command:

; Select SCOPE_IDENTITY() AS " + this.PrimaryKeyName; to the

It's possible that MySQL doesn't like this...

Best Regards,