Error "The search key was not found in any record"

[Michelle]

I have a query that has the following sql code all it is doing is updating
another table from a data push. It worked up till this weekend now I am
getting an error when I try to run it that says "The seach key was not found
in any record.

UPDATE tblInmtinfo RIGHT JOIN inmtinfo ON tblInmtinfo.IN_INMNUM =
inmtinfo.IN_INMNUM SET tblInmtinfo.IN_INMNUM = inmtinfo.IN_INMNUM,
tblInmtinfo.IN_NAME = inmtinfo.IN_NAME, tblInmtinfo.IN_RACE =
inmtinfo.IN_RACE, tblInmtinfo.IN_BLDING = inmtinfo.IN_BLDING,
tblInmtinfo.IN_SECTION = inmtinfo.IN_SECTION, tblInmtinfo.IN_CELLDRM =
inmtinfo.IN_CELLDRM, tblInmtinfo.IN_BEDNUM = inmtinfo.IN_BEDNUM,
tblInmtinfo.BSCB = inmtinfo.IN_BLDING & "-" & inmtinfo.IN_SECTION & "-" &
inmtinfo.IN_CELLDRM & "-" & inmtinfo.IN_BEDNUM;

 

[Allen Browne]

Michelle, this error sometimes means a corruption has occured in an index.

Try a compact/repair:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

More suggestions on recovering from corruption:
http://allenbrowne.com/ser-47.html