>I have MDAC version 1.5 installed. I 've tried the above i.e.
> ORecordSet.Open SQLStatement, oConn
>in VFP 5.0, and everything works fine. So I can't really understand why the app shouldn't work.

I don't know what to tell ya. You're using the Control Edition of VB, aren't you? That's probably the problem. I don't know why. Maybe the FoxPro forum will provide you with an answer. They get much more traffic, so someone is bound to give it a shot.

Best,

Jody