VB6 ADO Recordset Limit

vb6 ado recordset
StoneJedi picture StoneJedi · Jun 1, 2011 · Viewed 10.7k times · Source

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?

Answer

vcsjones picture vcsjones · Jun 1, 2011

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.

Related questions

Access-SQL: Inner Join with multiple tables

i have multiple tables in a database: tblOjt ID studentid courseid companyid addresseeid dateadded datestarted dateended ojthours 1 3 1 1 1 9/25/2013 500 tblStudent ID lastname firstname middlename course gender renderedhours dateadded archive 3 Dela Cruz Juan Santos BSIT Male 500 tblCourse ID coursealias coursename hours 1 BSIT Bachelor …

Read More
VB6 ADODB.Recordset RecordCount property always returns -1

I am trying to get some old VB6 code to work with SQL Server Compact. I can connect, open the database and all seems well. I can run insert select commands which work. However the ADODB.Recordset RecordCount property always …

Read More
How to properly add new records to empty recordset manually?

How to add new records to a new & empty ADODB.Recordset manually? Right now, here's what I'm doing that isn't working: Dim rs as ADODB.Recordset rs.Open Dim Fields() as String Fields(0) = "SomeFieldName" Dim Values() as String Value(0) = "…

Read More