Hi,

A couple of days ago I moved my A2010 tables to SQL Server 2008 Express using SSMA and all seemed to go well. However, I've now noticed that one of my tables is locked. In other words I can't edit existing records or add new ones. All the other tables work just fine.

Can somebody please advise me how to unlock the table, or if that's too simplistic a hope a pointer in right direction would be good.

I've only had the pleasure of playing with SQL server for about 2 days now so still have a lot learn, so hoping for simply worded response.

I'm using SSMS if that makes any odds and the the tables are DSN-Less linked to 2010 sr1.

SmallTime

Ah-ha, found the answer, table's primary key in SQL Server had been removed during conversion!

SmallTime

Thank your post much

Glad problem solved, my first thought reading this before I saw the primary key missing was blocking. It happens in SQL Server, and you have to intervene through SSMS to undo it. Rare, but it does happen. FYI.