I think the problem you may be having is that the data returned by the 246th row is too big to fit in the buffer. I've had similar problems with Access. If raising the buffer past 3,024,000 bytes is not a possibility you should look at reducing the amount of columns returned. It also seems wasteful to do a 'SELECT *' and only use one column.
Good ideas, but nothing seemed to help. I tried selecting different sets of data from the table and all of them seemed to break at 240-250 records. I tried selecting only a single column and that didn't work either. Thanks for the suggestions.
-----------------------------------
Washizu Acoustic Rock