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

Glad it helped.