|The search key was not found in any record|
You can find about 13,800,000 results in google
and 45,200,000 results in bing
for the term "The search key was not found in any record". but
no result will suggested that the solution is hidden in your table, in
the table index.
ms access 2000
Its easy to add an index to Access database table but you have to remove it when time have came.
I have this table and it have old leftovers i have used in previous project as indexes. those indexes are refers to an old fileds which are not in use any more. afer long research i try to do some clenning and refreshing the old idexes and problem solved.