Hi Brian,

I have not used MMF for .NET with Access data but I do know that Access does not allow for multiple Select/Insert/Delete/Update statements to be chained together like SQL Server allows and other databases. When you set RetrieveAutoIncrementPK to true, what MMF does is append a second select statement to the insert command to retrieve the values. The error you are getting is because of the limitations of Access to know what to do with this second commend being appended to the insert statement. You will need to manually retrieve the primary key values and not use the RetrieveAutoIncrementPK property.

>Earlier this week I post a problem I was have saving data in my primary BizObj.
>The BizObj. is working against an Access DB. I was reciving the following Error.
>Characters found after end of SQL statement. I only get this error when Me.RetrieveAutoIncrementPK = True . If I set the property to false I don’t get the error. The problem is that I’m using auto increment Primary Keys in this DB and need to retrieve the value in order to populate child records. Has anyone had this problem or is there a way around this? This is a real show stopper for me.
>
>Any help would be greatly appreciated!
>Thanks
> Brian G