I have a table we just transferred from MS Access to SQL Server 2016.
It's a simple table for creating load numbers for shipping products. Using access we link to the SQL Server and we are able to add new records and create a load number but we can not edit the record after that. What setting am I missing?
It must be in permissions. Any ideas? I have noticed that I can edit some older records and records that I create so it must be a permissions setting somewhere.