Re: "Search key not found" error!!!
From: goForth (goForth.14dgez_at_mail.mcse.ms)
Date: 04/07/04
- Next message: Terry: "field names"
- Previous message: Graham Mandeno: "Re: Date Time Difference"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Apr 2004 16:48:08 -0500
I stumbled across this forum when I was getting the same error message
for an Access table. I could run a select query no problem. But when
I tried to run an update query I'd get the error "the search key was
not found in any record". The Access help said this was common when
using ISAM SEEK - whatever that is! Anyway... the quick fix I found
for this was to look at the design view of both tables in my query and
check for memo fields which contained an indexing. Memo fields can't
be indexed and this is the cause of the error. I removed the index and
no problems. Hope that helps.
BarbaraC wrote:
> *I am experiencing some very bizarre behavior with my
> Access 2000 app! I have been occasionally getting the
> error "The search key was not found in any record". The
> app is in a separate database and the data is in another
> database - tables are linked in the app DB. Even if I go
> into the table containing the data and try to delete the
> record I get the same message so it appears not to be a
> code problem in my form!
>
> I read KB article 301474 about this error, but it
> indicates that the problem occurs when saving design
> changes or compacting a database - neither of these are
> when my problem occurs.
>
> My users are using Windows 2000, however the new company
> laptop I was given about 2 weeks ago is running XP
> professional (where I have been making code
> modifications). Could this possibly have anything to do
> with the cause of my problem? If I create a new DB on my
> laptop with XP Prof and then put it on the network and
> users with Win 2000 use it would that be an issue?
>
> Any help would be appreciated! *
-- goForth ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message429713.html
- Next message: Terry: "field names"
- Previous message: Graham Mandeno: "Re: Date Time Difference"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
