Can't Update Value In Field After Interrupting Query

[JeffGeorge]

I have an Access table that is linked with an ODBC connection to an MSSQL table. I need to replace a particular value in one field with another value. Since it was taking so long by doing a Find & Replace, due to the large number of records in the table, I CTRL-BREAKed (broke?) it. I then filtered the data down to the value that I want to replace and tried another Find & Replace. Now I only get this message:



'The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record.'

I've been fighting with this for over an hour now. How do I get the changes in there?

I even went into MSSQL and did a query and the table is still showing the old value. However, when I search the SQL results for that old value it said the value was not found, even though I was looking at it right in front of me.

Help!

[June7]

Access has a Compact & Repair utility that often fixes data issues like that. Does MSSQL have similar?

[JeffGeorge]

I eventually just unlinked the table and then linked it again in Access. That seemed to work, as the updated values were appearing in Access after I re-linked.