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)?

 

[Pat Hartman]

You can turn off warning messages but this is not a warning. It requires a response.

I've used DB2 many times with large recordsets and never run into this message.

Why not link to the table rather than importing it. Clearly your DBA is attempting to limit network traffic. If you use selection criteria for your queries, you should be pulling the minimum number of rows across the network.

 

[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