Form Filtering - VEEERY slow... =/

[diego.gsantos]

Hello everyone.

I have an application in access 2010 with one main form, where users search for costumers
In this form, users can see some info about these costumers like:
Name, Oficial Name, Assigned_to, category

I'm currently using the default "search bar" from access filters, so users can search by both name and oficial name.

The problem is: as the database is growing, it's becoming VEEERY slow... Sometimes users start typing and access start to "load" for 10~20s until it finds the name matching the text in the little "search bar".

Someone could help me in how can I speed it up?

Or maybe an alternative aproach that i could use to solve this issue?

Thank you.
Diego-gs

 

[pr2-eugin]

How is this search performed? Queried in the OnChange event of the Unbound text box? Or complete one full name and click button to filter?

 

[diego.gsantos]

How is this search performed? Queried in the OnChange event of the Unbound text box? Or complete one full name and click button to filter?

Hello.

Maybe I'm not expressing me very well... english isn't my language, but the search that I'm talking about, is the default search from filters, in the bottom of the form.

I can't attach links, so I can't show you the search bar... but it's located on the bottom of every form.