Search results

gemma-the husky You are correct. I wasn't searching for mid string at the time, it still takes up to 8 seconds if I search mid string. But I think I have a way around that now. Dave

Hi. I started down the road you were suggesting. And realized that the column I was searching on was not indexed. I thought because I had a primary key and only one other column that was the same as having the column indexed. When I added an index to the column itself the searches drop to...

Wow, you are defintely over my head. But I will try to figure it out and work through it, it sounds promising. Thanks.

Galaxiom Thanks for your response. There would be way to many combinations for my to partial strings table. I will look at the stored procedures. Thanks

Galaxiom Thanks for the suggestion, I have been meaning to switch to mysql for a while so I did. The operation takes even longer now. I know this is not a mysql forum but since we started in access perhaps you can help? I have 1 table with about 9 million records. The first column is id...

Hello I am using Access 2003. I have a form and on it a button that runs some VBA code. The VBA code can take a while to execute. I would like my user to be able to continue using the form while the code runs in the background. As opposed to what happens right now which is the form...