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

G

Guest

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;
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query Problem 1
Union issue 1
Union/Join issue 1
Runtime Error .Refresh 1
Problem with Update Query 1
Any idea why... 1
The search key was not found in any record 4
access error msg "the search key was not found in any record" 2

Top