Access 2000 Find Problem

[cc0316828]

I'm having a problem with Access 2000 that I haven't been able to figure
out. For some reason, the edit-find command will only find the string I'm
searching for in a very nearby record - it won't find it in subsequent
records. I'm asking it to search the whole table, any part of field, and
'all'. There is no "search fields as formatted" button in 2000. If I click
3 records away, it will find the string 3 records down, but if I click 10
records away (above) it won't find the same string on the search. I'm
confounded. I'm running XP - SP1 and SP3 of Access. I've run detect and
repair. Any Ideas.

 

[G. Vaught]

XP has a new service pack SP2, which you should probably install.

I don't think your problem is Service Pack related. It is probably more how
you are constructing your search.
Give us an example of what you type in the find box and where your cursor is
at the time of the find? This makes a big difference on how and what is
searched.

 

[cc0316828]

I might do SP2 soon, but agree it's probably not related to that. I'm
running Jet 4.0.

Sample search. It's an addresses table. Ordered (for illustration purposes
by address ID).

First search: cursor in address ID 137. Searching on street number 4827 (as
input, no special characters or wild cards) which is in record 139. Search
parms: 1: Look in "Addresses:table, 2: Any part of field. 3: search all,
match case not checked, search fields as formatted is grayed out and
unchecked. This search works.

Second search: cursor in same place (record 137 address id. Searching on
street number 3049 in record 141. All other parms the same.

This search works.

Third search: Cursor same place. Now searching on record 136 with number
7735. All other parms the same. This search fails.

Trying similar this at different points on the database seems to provide
this pattern: 1) will always find the string in the same record. Up to 5
records down (never above) it will sometimes find it - the closer the record
the better. Beyond 5 records it will never find the string.

Okay, I'm clueless.....