26.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
).