Nicholson, Karen
cyx5 at cdc.gov
Wed Mar 16 11:37:36 CST 2005
You tell him! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, March 16, 2005 12:34 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Speed of 2000 vs 2003 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com