Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Query Result Limit

Status
Not open for further replies.
Esoteric

Esoteric

ISP
Feb 10, 2001
93
US
Does anyone know if there is a limit to how many records the query will result. I have one that has 9714 records and it works great and I have one that has 10,000+ and I get no results. I read someplace a couple years ago about a 10,000 record limit but I can't recall where and what for. Any Ideas before I slam my head into a wall :)
 
Sort by date Sort by votes
I have pulled over 25,000 records at once, I don't think there is any limit, except that you probably can't have more than say 4 billion or so. "Programming is like sex, one mistake and you have to support it forever."

John

johnmc@mvmills.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
352
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
ASP Classic - SELECT query does not work
Replies
11
Views
371
guitarzan
guitarzan
leifoet
  • Locked
  • Question
How do I turn the result of a multiplication in a VALUE that can be entered into a database table ?
Replies
12
Views
193
leifoet
leifoet
leifoet
  • Locked
  • Question
How to compare dates in a SELECT query
Replies
12
Views
294
guitarzan
guitarzan
leifoet
  • Locked
  • Question
How do I save a list of the screen created with a select query
Replies
1
Views
145
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top