Nicholson, Karen
knicholson at gpsx.net
Thu Feb 19 11:58:19 CST 2004
In Access, under Tools Options, Edit Find, do you have the search set to default to ODBC? And someone else once told me on that same set frame, one should set the total number of records to read 0. -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] Sent: Thursday, February 19, 2004 12:52 PM To: SQLServerList Subject: [dba-SQLServer] Faster Searching I have a SQL2000 table with about 5000 records. This table is linked to an Access DB. When I try to search records thru the form, it is taking about 5 minutes to find a record. I added an index to the field that is being used to search, but it didn't make a difference. Is there anything else I can do to speed up the Find process? TIA, Mark Boyd Sr. Systems Analyst McBee Associates, Inc. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com