[AccessD] Speed of 2000 vs 2003

I'm looking at MSDE as an interim step.  The number of users will probably 
never be over 2-3. Right now, only 1.

Rocky

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 16, 2005 9:33 AM
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
>