HI:
I am using ACCESS'97 as front-end to SQL SERVER 7 : I need
convert existing ODBC connections using DAO to ADO using
OLEDB connections.
How can i specify the new recordsource to the form in
code ?

Thank You for any assistence

You can't.

The forms in a97 are DAO.

You can use ADO recordset objects in a97, but you can't use/bind them to a
form. (you can in a2000 and beyond).

On the other hand, I can't imagine why you want to do this anyway...

--
Albert D. Kallal
Edmonton,  Alberta Canada

http://www.attcanada.net/~kallal.msn