>>>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.