>>>>I have a data source class that provides ADO record sets and everything seemed to be great with navigation until I recieved the 3219 Operation not allowed in this context Error. This is on a simple select * type rs BOF and EOF are false. Anyone have any insight on this.
>>>>
>>>>My connection string:
>>>>s_conn = "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=" & m_strTable
>>>
>>>It errors just on the Select?
>>>
>>>Try adding Exclusive=No to the connection string.
>>
>>Oops. The error occurs on moveprevious but not on movenext. The select is beautiful the forward nav works as expected, reverse nav is T.U.
>
>You are probably retrieving a forward-only recordset. You can set the connection or recordset CursorLocation property to adUseClient to create a static rs so you can go forward and backward on the recordset. Or, if you need the server side, set the appropriate attributes so the rs is not forward-only.
>
>Hope this helps.

My Thanks!