If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
To many records to query?
My database has 1 millon records and when I run a query I
see it start (hour glass) then just stop. Could this be a limitation of RAM or to many records to query? Thanking you in advance for any help. Simrun |
#2
|
|||
|
|||
To many records to query?
Simrun
Are you running your query over a network? Do you have exclusive access to the tables? What's your operating system and Access version? Are the tables linked via ODBC? Are there any indexes on the tables? How many tables and fields are you trying to join together to create your query? Do you have any VB functions you created that are calculating on every record? How much RAM do you have in your PC? What other applications do you have open? How fast is your PC? A lot of factor be the cause of this. In the end, sometimes it just takes a long time. I have queries I've run that access 26 million records, and they're the one's you just walk away from, and pray the network doesn't log you off during the night. Good luck. Mark "Simrun" wrote: My database has 1 millon records and when I run a query I see it start (hour glass) then just stop. Could this be a limitation of RAM or to many records to query? Thanking you in advance for any help. Simrun |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Append Query problem -- producing WAY too many records. | Richard Hollenbeck | Running & Setting Up Queries | 3 | July 24th, 2004 09:32 AM |
displaying all the duplicate records in a duplicate query | Paul James | Running & Setting Up Queries | 6 | July 15th, 2004 09:28 AM |
append Query duplicating records | Alex | Running & Setting Up Queries | 1 | July 8th, 2004 01:31 PM |
Query combining multiple records from one table can't add records | Clint Marshall | Running & Setting Up Queries | 4 | July 8th, 2004 01:25 PM |
can't append records in append query | Greg Clements | Running & Setting Up Queries | 1 | July 2nd, 2004 04:29 PM |