Corrupted key - URGENT PLEASE

[mapat]

Hello,

I have a problem. I have an ACCESS2007 front end linked to a SQL Server 2008 back end which resides on a server. Somehow the primary key of a record in table 'A' on the back-end got corrupted. For instance, the record key is supposed to look like this "4NYC004571" and it looks like this "4NYC0045$1". It is not exactly the dollar symbol but it's a strange character. This is preventing me from opening the whole table. I tried deleting that specific record but the query does not respond. Can someone give me a helping hand on this?

Thanks

 

[Atomic Shrimp]

Are you trying to do this from within Access? - I doubt that would work.

Are you able to append all rows but that one into a fresh copy of the structure?

 

[mapat]

Are you trying to do this from within Access? - I doubt that would work.

Are you able to append all rows but that one into a fresh copy of the structure?

I'm trying to delete that record from SQL Server. I also tried doing it from ACCESS. I'm not able to append any records.

Thanks