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.

Thanks for the Help

Sonali