>oRecordset.Open tablename, oConnection works fine but
>oRecordset.Open "SELECT * FROM tablename", oConnection gives an error !
>
>What may be the problem ?

What's the error you receive?

jody