Access: slow search on linked tables

Hello everyone.

I have a MySQL table with about 18,000 records with MySQL ODBC 5.1
connected to a front-end Access.

If I open the table in Access directly, shows me all results.
If I do a search with eg Ctrl-B on the Primary Key of the table, I
take ages to reach the record sought.

Example:
The key of the table is the ID field, a consecutive number [1 ..
18000]. When you open the table and try to find the ID 16500, is
found, but in a very long time.

The key, by definition, has an INDEX B-Tree, but it seems this is
ignored when searching to access (if not, do not understand).

How can I optimize this search?

Note:
My users are used to search directly in Access on the table / view with Ctrl + B

Thank you very much.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]