Hi Dean,
Thank you for sharing the final resolution with us. If you have any
concerns or questions, please feel free to reply to the threads.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Dean Slindee" <
[email protected]>
| References: <
[email protected]>
|
| It seems that Access has a "data management" record limit built into the
| datasheet display logic.
| Here is what I did get more than 10000 records returned to the datasheet.
|
| 1.. Launch the datasheet.
| 2.. At the bottom of the datasheet click on the "go to end of records"
| button, the one far right 3. A dialog box is displayed allowing you
| to specify the max records to return. Key in 20000.
| 4. Click OK and the datasheet will be refreshed with the entire
| dataset.
|
| Thanks for pointing me in the right direction.
|
| Dean Slindee
|
| | > On Wed, 15 Oct 2003 22:35:56 -0500, "Dean Slindee"
| >
| > >In an .adp front-end over a SQL Server 2000 backend, a datasheet is
| > >currently returning a recordset of 10000 rows. The project's
| > >Options|Advanced tab|Client-Server settings|Default max records count
is
| set
| > >to 20000 records.
| > >
| > >The datasheet is being fired by calling a macro which merely opens the
| table
| > >in edit mode.
| > >
| > >Is there any place else where a max of 10000 rows is set?
| >
| > I don't think so. Access by default will display a portion of the data
| > immediately, without waiting for the entire recordset to be shown. Try
| > explicitly moving to the end of the recordset in code after opening
| > the datasheet.
| >
| > John W. Vinson[MVP]
| > Come for live chats every Tuesday and Thursday
| >
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
|
