Read Rows Warning

[DKEND]

I am selecting records from DB2 into a temp table in Access. My problem is that every time I run this sub it will post a Warning that says you have read 1000 rows. Retrieve another 1000 rows? Y/N..... I have set the warnings to False, but still get the message. There are 25,000 rows in this BDB2 table so I really don't want to click Y 25 times. Is there a setting in Access to turn this off or better yet change it from reading 1000 rows at a time to a different number like 20,000.


Thanks
Darin

 

[Travis]

This may not be an issue with Access it might be how you are getting the Data from DB2.

What code are you using?

Are you using a utiltity to get the data (Such as an ActiveX control)?

 

[DKEND]

Thanks for the help everyone.

This is not an Access problem after talking with the DBA I found out it is a setting for our RRDG ODBC called MaxFetchRows

Thanks again
Darin