Theo Fitchner
asked on
Query Doesn't Allow New Records to be Added When Linked to SQL Server Backend
Hello everyone. I have a Microsoft Access 2010 app. The JET tables have been migrated to SQL Server 2012 Express and I connect to them from the Access app via linked tables.The app is still in development and so I still have a copy of the app connected to local Access JET tables. The problem is with one of my queries that is used as the record source for a form. The query involves 3 tables.
In the app version using local JET tables, the query runs fine and I can add a new record to the recordset both in the query results window and in the form that's based on the query. However, in the app version linked to SQL Express, I cannot add a new record to the recordset neither via the query results window nor via the form. The results are editable; I just cannot add a new record. This is strange to me because it works just fine in the JET version of the app.
Funny enough, constructing the same query (as a view) in SSMS allows me to edit and add new records in the results recordset,
As far as I can tell, my relationships and indexes are set up properly. I have attached a screenshot of the query in the query design window.
Please help.
In the app version using local JET tables, the query runs fine and I can add a new record to the recordset both in the query results window and in the form that's based on the query. However, in the app version linked to SQL Express, I cannot add a new record to the recordset neither via the query results window nor via the form. The results are editable; I just cannot add a new record. This is strange to me because it works just fine in the JET version of the app.
Funny enough, constructing the same query (as a view) in SSMS allows me to edit and add new records in the results recordset,
As far as I can tell, my relationships and indexes are set up properly. I have attached a screenshot of the query in the query design window.
Please help.
No screenshot attached.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry. This is the screenshot.
Problem-Query.JPG
Problem-Query.JPG
ASKER
Anders's suggestion worked. I included the Primary Key of all the tables in the query in the query design grid and I can now add a new record to the record set. I'm used to the Access way of doing things. My bad.
Thanks very much. Cheers.
Thanks very much. Cheers.