PC Review


Reply
Thread Tools Rate Thread

Re: Default max records for ADP

 
 
Norman Yuan
Guest
Posts: n/a
 
      23rd Jul 2009
That is just a limit for directly showing records in ADP, if you, as the ADP
app developer wish to see data directly in table (well, if you do not mind
the long loading time for pulling 2 billions of records, overload the
network/server and your ADP computer, and spend a couple of years to scroll
them over).

In real practical need, there is absolutely no need to pull that many
records to show them visibly at once. You should always do query selecting
rather than directly open the table, if the table have a lots records, say 2
billions, or 2 millions, or even 20000.

"aspfun via AccessMonster.com" <u53138@uwe> wrote in message
news:9978add03d3e0@uwe...
> In ADP, option, advnced, there is a box for client-server settings,
> default
> max records can not set more than 2,147,483,647. Is it coming from SQL
> server
> limitation?
>
> --
> Message posted via http://www.accessmonster.com
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get MAX, MAX -1, MAX -2 pilzner Microsoft Excel Misc 2 5th Aug 2005 07:57 PM
How to control ADP Connection when start ADP =?Utf-8?B?TmlraQ==?= Microsoft Access 0 11th Nov 2004 10:12 AM
Max Records on Combo Box form A2003 .adp Microsoft Access Forms 1 7th Oct 2004 03:44 PM
Max Records in ADP form Peter Crickman Microsoft Access Form Coding 2 12th May 2004 07:06 PM
Re: ADP routine fails in ADP. BJ Freeman Microsoft Access ADP SQL Server 0 7th Jul 2003 04:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:10 AM.