I am trying to get a recordcount from an Oracle table and the program crashes saying that this operation does not support movements in the cursor. I have played around with the ways of opening up the cursor and it did not work.<BR><BR>Can someone please help?<BR><BR><BR><BR>My code is below.<BR><BR><BR><BR><BR><BR>Private Sub Command1_Click()<BR>Dim adoConn As ADODB.Connection<BR>Dim adors As ADODB.Recordset<BR>Set adoConn = New ADODB.Connection<BR>Set adors = New ADODB.Recordset<BR><BR>adoConn.Open "Provider = MSDAORA;Data Source = test;user id = vdesai;password = oranges"<BR>adors.Open "collapsed", adoConn, 3, 3<BR>adors.MoveLast<BR><BR><BR>End Sub<BR>