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?
Our community of experts have been thoroughly vetted for their expertise and industry experience.