I have a form that I used to be able to add/edit records on. Since I moved the Access tables to SQL Server and converted the Access queries to SQL Views, the form no longer allows adds/edits.
I had the Access form's Recordset Type set to "Dynaset (Inconsistent Updates)".
The SQL looks the same on the prior Access DB and the now SQL DB. It's a left join on two fields.
Can anyone help or send me in the right direction please? I thought I was finished with the conversion but this issue popped up and it's likely going to affect user data entry on many forms/tables/views.