Default max records for ADP

  • Thread starter aspfun via AccessMonster.com
  • Start date
A

aspfun via AccessMonster.com

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

Norman Yuan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 max rows 14
Set as Default Template not working 0
How to show all records for a table in ADP? 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Outlook linking to non default browser Edge 0
Default local file location - folder redirection slowness 0
ADP Update Query does NOT update ! 3
Default Max Records 3

Top