Hi Benn,

Well , Fields Collections are part of Recordset Object. So if you are getting Fields collection, u must have recordset object also. Can u please post your code. Or Check the following :

First
Check your Recordset's CursorType property (Make it Dynamic Cursor, in ur previous code u defined a Constant but never used in your code)

Second
Check your Recordset's CursorLocation property (try to change Client or Server Side)

HTH


>Hi Ramesh,
>
>Your advise worked fine. But now I ran into the next problem. When working with the recordset in VB, I'm only allowed to display the first record. I have tried with "Movenext", but I'm told that this method is not supported.
>
>Then I tried "Typename" but it told me that I was working on a "Fields" and not on a recordset.
>
>Hope you also can help with this.
>
>
>
>>Hi Benn
>>
>>"oConn.Close" is creating the problem. If you close the connection, the recordset which is bounded by "oRecordset.ActiveConnection = oConn" also closed.
>>
>>You can also open the connection in recordset itself like :
>>
>>oRecordset.Open("SELECT * FROM Freetime","DRIVER=Microsoft Visual FoxPro Driver;" + ;
>> "SourceType=DBC;SourceDB=D:\DATA\VFP_60\OLE\ADO.DBC;" + ;
>> "Exclusive=NO;BackGroundFetch=NO;NULL=NO;Collate=MACHINE")
>>
>>HTH