DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Mar 16 11:45:46 CST 2005
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