Access find query very slow. Looking for alternate solution

[carl R]

I recently updated my Access v2.0 application to MS access 2007 and migrated the access v2.0 database to MySql. It is fully keyed (i.e. primary and secondary keys).

After the access migration I found access searches are very slow. reason:
1-the user clicks on a field of interest in a form.
2-then clicks control-F.
3-the access search function appears
4-The user enters the data of interest.
5-the OK button to initiate the search (query).

What I found is if the user does NOT uncheck the button "Search as formatted" on the "find" form, access will:
1- first do a select without a where clause and read ALL the records of the database into access.
2- Then access will search the resultant set for the data of interest.

The query can take minutes.

However, if the user DOES UNCHECK the "Search as formatted" button before clicking OK, access will create a select with a where clause. The search completes almost instaneously. Very fast.

I have searched the Microsoft web site and apparently the problem is the way the MS jet engine formulates SQL queries. MS suggests re-writing the find function.

I know I can write something to fix this, but I am hoping this is a problem that has already been solved and can be purchased a off the shelf solution. Perhaps a plugin for MS access 2007.

Can anyone suggest somthing?

Thanks
carl