Is there a limit to records in recordset? 1

[OrthoDocSoft]

Folks,

I Googled this, but couldn't find the answer. If I do this:

strSQL = "SELECT * FROM MyTable  '(and I know this is sub-optimal....) 

adoRecordSet.Open (strSQL), adoConnection, _
adOpenForwardOnly, adLockReadOnly
...

Is there a limit to the number of records that can be pulled into the recordset? Is it just over 32,000? I'm getting an "Overflow" error in a little app I'm writing and I suspect this is the cause.

Thanks,

Ortho

"you cain't fix 'stupid'...

 

[gmmastros]

I don't know what the limit is, but I can assure you it is much more than 32,000. Just out of curiosity, what type of database are you using? Some databases support computed columns, which could be failing for you.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SkipVought]

If you are observing, "just over 32,000," you are probably using an index varaible that is declared Integer (32,767 max)

Try declaring as LONG.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[OrthoDocSoft]

Skip,

Spot on! I have been changing my integer types to longs, but not that one! Can't believe I didn't see that sooner.

Thanks much. And I can't believe (but here, actually, I can) that I got two replies in 15 minutes. This site is the bomb.

Ortho

"you cain't fix 'stupid'...