CODEWITHSUNDEEP
vb6adorecordset
StoneJedi
StoneJedi

Reputation: 575

VB6 ADO Recordset Limit

Please don't laugh because I'm asking a VB6 question? I have to do some maintenance work. Does anyone know what the maximum number of rows can be returned to a VB6 ADO Recordset? If there is a limit, is there a preferred method for getting around it?

Upvotes: 6

Views: 12332

Answers (2)

Matt Wilko
Matt Wilko

Reputation: 27322

The RecordCount property is a (signed) Long (as is the MaxRecords) so it won't be able to hold more than 2,147,483,647 rows

Upvotes: 1

vcsjones
vcsjones

Reputation: 141608

There is no limit (see link for documentation), but you can provide one if you want. There should be a MaxRecords property that you can set. You have to set it before you open the recordset.

Upvotes: 5

Related Questions