I'm using ado object in VB6 with an sql recordset. My code is:
Set RSord = New ADODB.Recordset
RSord.Source = "select * from Orders where IDOrder = " & strIDord
Opening the recordset it is very fast.
But after the following instruction:
Set frm.AdOrd.Recordset = RSord
this is very very slow.
Thanks in advance for any suggestion.