Seeing two different backends via one ADO project.

[Mike Durrant]

Dear People with knowledge;
I am trying to migrate the front end of my data warehouse
from Access 2002 to an ADO project using OLE DB access to
my MS SQL server and to the main data source OLE DB,
ODBC, Other link to AS400. I have been trying to
implement the OLE DB function inside of Client Access
Express V5.R1 with out success. The main goal of this
migration is to speed up the daily update / refresh the
data warehouse on the SQL server using the "faster" ADO
functions. I have evaluated most of the articles on this
type of interface and reinstalled the Client and
registered it manually and so far nothing works. Please
help!!!!