"Search key not found" error!!!

[BarbaraC]

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!

 

[TC]

My understanding is that this message normally indicates a corrupted
database. Perhaps copy everything (code and data db's) into new databases, &
see if it happens again. If it does, see what's causing the corruption;
perhaps dropped network connections, etc. etc.

HTH,
TC

 

[goForth]

I stumbled across this forum when I was getting the same error messag
for an Access table. I could run a select query no problem. But whe
I tried to run an update query I'd get the error "the search key wa
not found in any record". The Access help said this was common whe
using ISAM SEEK - whatever that is! Anyway... the quick fix I foun
for this was to look at the design view of both tables in my query an
check for memo fields which contained an indexing. Memo fields can'
be indexed and this is the cause of the error. I removed the index an
no problems. Hope that helps.

*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!

-
goFort