 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2005Trouble filtering
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 > 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 [quoted text clipped - 6 lines] > Thanks > Dimitris Are all of the fields you filter on indexed? (they should be)  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com 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 >> 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 [quoted text clipped - 8 lines] > > 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 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. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com 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 >> Thanks for your answer Brandt. >> What exactly do you mean indexed? As I mentioned before I am new in [quoted text clipped - 13 lines] > 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 [quoted text clipped - 4 lines] > Thanks > Dimitris I always use the Google groups search tool. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.