ODBC buffer size.... ???

update..... what does an ODBC fetch buffer size of 32,767 mean? does that mean MSAccess will bring back 32,767 characters in one select and that's it? for example, if i use dbaccess to dump a list of owner.table names from the IDS7 engine below, and do a character count on the file, it is very large, ... surpasses 32,767 characters. but the IDS9 engine below ... while it has 20,000+ tables, the owner.table names are smaller in size, potentially fitting in the 32,767 fetch buffer size...... i don't know enough about this ODBC stuff. I know i can not increase the fetch buffer size in the ODBC setup, but it appears that the MSAccess session can't bring back the entire table list because the select output is larger than 32,767 characters? help? thanks, NJ

yup, that appears to be the case... i isolated 1 table with 13 rows, created a new database with the one table and loaded it .... then created ODBC connection to the test database with the 1 table... now MSAccess did not puke on the table list.... it easily fit in the 32,767 fetch buffer size.... another day... another lesson learned... NJ