Recent content by TraciTheProgrammer

I'm not sure that we are talking about the same issue, but the problem I had was that I converted an Access database to a SQL Server database. Then I opened Access and linked the tables, but one table was not editable. The error message had to do with record locking, which was very confusing...

I had this same problem and it turned out to be something obscure. See Microsoft Article Q280730. You can't have NULL bit fields. Do you have any? If so, you must specify the default value as =0. You must also change any existing records -- if NULL, change the value to 0.