I have connected an Access table to a table in SQL server and the table values can be updated without any problems in both SQL and Access. However, when I try to add a new record in Access, I get the error:
"[SQL Server] Cannot insert explicit value for identity column in table 'Table' when IDENTITY_INSERT is set to OFF. (#544)"
I have checked that the composite key and foreign keys have valid values and I can insert the same values from the SQL side with no problems. I've read that it is possible to toggle IDENTITY_INSERT, but I don't see how that is possible since there is no way in Access to edit the SQL code that links the tables together. Any ideas what might be going wrong here?
