do not use Ctrl-F, it will retrieve all the records and then try to find the specific record.
Instead change the form record source property dynamically with SQL statement having appropriate where clause, result will within eye blink. regds, -----Original Message----- From: Sean Meegan [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 18:09 To: Subject: Native MS Access 97 Searches from an Access Form I'm running Access 97 as a front end to a MySQL ODBC linked table. Everything is working fine with the exception of "long searches" from within Access. In the past we would be able to go to any one of the fields from within the Form, and then do a Ctrl + F to find a record by whatever value we chose. Results would take about a second when they were native Access table searches. Since converting them it takes about 40 seconds or more.. I've indexed the fields, and optimized the tables, still long searches. All ODBC settings in the Control panel appear to be correct, ONLY Don't Optimize column width and Return Matching Rows are checked. Any Ideas? (Table is an 8 meg table with about 5 thousand records in it) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
