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

#1

There are more complicated ways to address this problem, but
compacting the data file worked for my 2007. I was getting it on an
update query.

(Note to self: Next time something goofy happens, compact BOTH app and
data files before hunting for other solutions.)

pemigh

#2

What you refer to as "something goofy" is often a minor corruption of the
app or data files. Compacting also repairs minor corruption.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley

"pemigh" <pemigh (AT) gmail (DOT) com> wrote

Quote:

There are more complicated ways to address this problem, but
compacting the data file worked for my 2007. I was getting it on an
update query.

(Note to self: Next time something goofy happens, compact BOTH app and
data files before hunting for other solutions.)

pemigh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.ms-access comp.databases.ms-access

"The search key was not found in any record" solution - 07-16-2010 , 11:01 AM

Re: "The search key was not found in any record" solution - 07-17-2010 , 06:57 PM