>Timothy,
>you have to set the maxrecords property before you open the recordset.

Below is the code I am using. Am I doing something wrong here?

' Create ADO connection object
Set loConnection = sdMtsObjectCreate(poMTSContext, "ADODB.Connection")

' Create ADO recordset object
Set loRsToBll = sdMtsObjectCreate(poMTSContext, "ADODB.Recordset")

' Open connection to data source
loConnection.Open APP_CONNECTION

' Allow "abc" = "a" to be true
loConnection.Execute ("SET ANSI OFF")

' Set maximum records returned (does not work)
loRsToBll.MaxRecords = 200

' Query data source
loRsToBll.Open tcSQL, loConnection, adOpenStatic, adLockReadOnly, adCmdText