(mysql.info) access-long-tables

Info Catalog

(mysql.info) optimize-access

(mysql.info) msaccess

(mysql.info) query-timeout

 
 23.1.11.11 I Have Very Long Tables. What is the Best Configuration for MyODBC to Access These Tables?
 .....................................................................................................
 
 If you have very large (long) tables in Access, it might take a very
 long time to open them. Or you might run low on virtual memory and
 eventually get an `ODBC Query Failed' error and the table cannot open.
 To deal with this, select the following options:
 
    * Return Matching Rows (2)
 
    * Allow BIG Results (8).
 
 These add up to a value of 10 (`OPTION=10').
 

Info Catalog

(mysql.info) optimize-access

(mysql.info) msaccess

(mysql.info) query-timeout