[AccessD] Speed of 2000 vs 2003

Rocky, 
  If you are trying to avoid generating additional licensing fees for
your customer, you can always push the mdb into MSDE or the newer Sql
Server 2005 express which is acctually the best MSDE release to date
because the governating process is off now, and you can run
essentially all the queries you need at a time.. but it is restricted
to 1 cpu.

HTH


On Wed, 16 Mar 2005 11:45:46 -0600, DWUTKA at marlow.com <DWUTKA at marlow.com> wrote:
> You need to go with local processing, which doesn't necessarily mean SQL
> Server.  Using an Access (Jet) .mdb with a Web interface, where the .mdb
> resides on the webserver, allows for very fast data access/searching.
> 
> Drew
> 
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Wednesday, March 16, 2005 10: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
> 


-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...