[AccessD] Speed of 2000 vs 2003

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



More information about the AccessD mailing list