DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Access-Long Tables

Info Catalog (mysql.info.gz) Optimize Access (mysql.info.gz) MSAccess (mysql.info.gz) 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 will not
 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.gz) Optimize Access (mysql.info.gz) MSAccess (mysql.info.gz) Query-Timeout
automatically generated byinfo2html