You should try posting your question in the VB forum.

>This is not really the forum to discuss a VB problem but the following problem is really driving me crazy. The following statement works fine
> Dim oRS as ADODB.RecordSet
> Set oRS= New ADODB.RecordSet
> oRS.Open "tablename", oConn ( oConn already opened)
>however if I try
> oRS.Open "SELECT * FROM tablename, oConn
>I get an error! Further if I try the same thing in VFP 5.0, no error are generated. Any suggestions.