Trouble filtering

  • Thread starter Thread starter Dimitris
  • Start date Start date
D

Dimitris

Hello I have a database with 1.500.000 records. The problem is that when I
want to filter (find a name or any other filter) it takes..for ever to see
the results of the filter.
Is my database too big? Is there anything I can do than just wait for
several minutes each time. Unfortunately because I am new in access I don't
know what to do and feel desperate with this situation. I would appreciate
any help that can make my database faster (at least the filtering which I
need)
Thanks
Dimitris
 
Dimitris said:
Hello I have a database with 1.500.000 records. The problem is that
when I want to filter (find a name or any other filter) it takes..for
ever to see the results of the filter.
Is my database too big? Is there anything I can do than just wait for
several minutes each time. Unfortunately because I am new in access I
don't know what to do and feel desperate with this situation. I would
appreciate any help that can make my database faster (at least the
filtering which I need)
Thanks
Dimitris
Click to expand...

Are all of the fields you filter on indexed? (they should be)
 
Thanks for your answer Brandt.
What exactly do you mean indexed? As I mentioned before I am new in Access
and am not familiar with everything. But something tells me it is not
indexed since nothing complexed is created.
Thanx
Dimitris
 
Dimitris said:
Thanks for your answer Brandt.
What exactly do you mean indexed? As I mentioned before I am new in
Access and am not familiar with everything. But something tells me it
is not indexed since nothing complexed is created.
Thanx
Dimitris
Click to expand...

Open the table in design view. For each field there is a list of properties
displayed at the bottom and one of them offers the choice of adding an index
to the field.

All fields that are commonly searched on or used in query joins should be
indexed. However indexes will slow updates somewhat and cause the file to
grow so you need to excercise some restraint as well and not just index
every field without due consideration.
 
Thanks Brandt. You helped me a lot.
Can I ask one question about the newsgroups. How can I search this newsgroup
with some key words in order to see if
what I am asking is already posted. What should I click in order to get the
oppertunity to search the posts here?
Is there some kind of possibility to do that?
Thanks
Dimitris
 
Dimitris said:
Thanks Brandt. You helped me a lot.
Can I ask one question about the newsgroups. How can I search this
newsgroup with some key words in order to see if
what I am asking is already posted. What should I click in order to
get the oppertunity to search the posts here?
Is there some kind of possibility to do that?
Thanks
Dimitris
Click to expand...

I always use the Google groups search tool.
 
Back
Top