Hi
I have a front end Access program on my local computer based on a MySql database stored on a server, using ODBC to connect. In the db I have like about 3000 records.
I inserted a Search button on the form, which works fine if I should make a search using the Whole Field, it lasts like 4 seconds to find the record Im looking for.
My problem is that if I try to search a field using Match Any Part of Field, it takes like forever to find it (like 8 minutes).
My form is based on a query, but when I do this search I notice too much internet activity, like if the search is being performed one by one on the server instead of my local query (Im I making sense?)
Is there something I can do to make this search more efficient?
Thank you for any help.
I have a front end Access program on my local computer based on a MySql database stored on a server, using ODBC to connect. In the db I have like about 3000 records.
I inserted a Search button on the form, which works fine if I should make a search using the Whole Field, it lasts like 4 seconds to find the record Im looking for.
My problem is that if I try to search a field using Match Any Part of Field, it takes like forever to find it (like 8 minutes).
My form is based on a query, but when I do this search I notice too much internet activity, like if the search is being performed one by one on the server instead of my local query (Im I making sense?)
Is there something I can do to make this search more efficient?
Thank you for any help.
