Access / MySQL - Slow Searches

[John A]

Hello,

I have migrated a customer contracts database to MySQL today, however I am still using Access as a frontend. This seems to have gone really well with no impact on the function of the database apart from searching (ctrl+f). Unfortunately searching now takes 10 times longer than it used to, I have read that a few others have had this problem but as of yet I have not found a solution that has been posted. One person mentioned they created there own custom search button but did not elaborate.

Does anyone know how I can create a button on my form (without using built in search) that will search and find in my contacts table and cycle through the matches (for company name field only) if they are partial?

Thanks