Charlotte Foust
cfoust at infostatsystems.com
Wed Mar 16 11:33:43 CST 2005
Rocky, With two tables of over 2million records each, the processing speed will suck no matter what version you use. For heavens sake, go to SQL Server before the thing falls over and dies! Charlotte Foust -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Wednesday, March 16, 2005 8:50 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Speed of 2000 vs 2003 Dear List: Is the processing speed in Access 2003 any faster than 2000? I have an mdb with two tables of over 2,000,000 records each and I'm looking for a way to speed up the queries without going to SQL. I have indexed all of the relevant fields in the tables. MTIA Rocky Smolin Beach Access Software http://www.e-z-mrp.com 858-259-4334 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com