DAO to ADO - Urgent

Hi,

I am struggling with my preexisting huge code with DAO recordsets and the need to use a ADO Data Environment.
Is it possible to define a ADO Data Environment,Connection or Command objects etc. and point them to a data control to get the data from that data control?
My problem is I already have a data control in my code getting the required data and now a third party control I am using needs a ADO Data Environment to be defined and linked to. Can I define a ADO Data Environment and then use the pre existing data control to get the data into it? Or else if it is possible through ADO Data Control, too its fine.

Any help or thoughts on this is requested for. Thanks a lot.

Sunil.

Hi,

I am struggling with my preexisting huge code with DAO recordsets and the need to use a ADO Data Environment.
Is it possible to define a ADO Data Environment,Connection or Command objects etc. and point them to a data control to get the data from that data control?
My problem is I already have a data control in my code getting the required data and now a third party control I am using needs a ADO Data Environment to be defined and linked to. Can I define a ADO Data Environment and then use the pre existing data control to get the data into it? Or else if it is possible through ADO Data Control, too its fine.

Any help or thoughts on this is requested for. Thanks a lot.

Sunil.

Could you give a little more detail.

Hi,

Thanks for the response. Let me give more details.
I am using a third party control in my project called Sheridan DBGrid-OLE DB. This control needs to be pointed to a ADO Data Environment or a ADO Data Control to populate the data into the grid. It cannot accommodate a DAO DataSource. My problem is I already have code which gets the data into VB intrinsic Data Control. My question is , is it possible to link this VB intrinsic data control to either a ADO Data Environment or a ADO Data Control, so that I can use the existing code and populate the data through ADO into the DBGrid? Please reply if I need to give more details. Thanks a lot!

Sunil

Hi,

Thanks for the response. Let me give more details.
I am using a third party control in my project called Sheridan DBGrid-OLE DB. This control needs to be pointed to a ADO Data Environment or a ADO Data Control to populate the data into the grid. It cannot accommodate a DAO DataSource. My problem is I already have code which gets the data into VB intrinsic Data Control. My question is , is it possible to link this VB intrinsic data control to either a ADO Data Environment or a ADO Data Control, so that I can use the existing code and populate the data through ADO into the DBGrid? Please reply if I need to give more details. Thanks a lot!

Sunil