Converted a database from an MS Access Jet to an SQL Server. Front end is Access. When editing a record, some tables cause the server to complain that somebody else has locked the record and I can't update it, when I am the only one logged in to the server. Inserting records into certain tables causes another error stating that the record could not be read back, so I can't retrieve the primary key (identity column) of the record inserted to modify it.
This happens both when using MS Access to insert/modify records, or even the SSMC (SQL Server Management Console), so I don't think it is an MS Access issue. Anybody have any insights?
When upsizing from Access, the SQL Server Migration Assistant will sometimes not add the SSMA_TimeStamp column, but you can force that in the settings.