Excel Add-In Using ADO to retrieve database records
 

Hello All,

OK, I am a NOVICE at best with ADO 2.8 but am enjoying it immensely! Here
is what I am in need to help with...

I am designing an Excel Add-In that will allow users, through different User
Forms, the ability to query information that is residing on an Access
Database. BUT the tables in the mdb are actually ODBC linked tables to
Oracle, IBM DB2, and SQL Server data. NONE of the tables in this database
where created, ALL are linked via ODBC.

When I build the User Form and run the code on my computer it works, but how
can I have other users be able to use the add-in and query the information in
my database when they don't have all the ODBC drivers or permission to these
ODBC tables? Is ADO the answer, or should I be using somthing else?

Also, can someone explain to me what a UDL file is and how to use it? Right
now I just "spell out" the connection in the VBE code.

Thanks!!!!

Excel Add-In Using ADO to retrieve database records
 

Hi,

You try Remote Data Factory objects.

regards
Karthi Ganesh


"cg" wrote:

Hello All,

OK, I am a NOVICE at best with ADO 2.8 but am enjoying it immensely! Here
is what I am in need to help with...

I am designing an Excel Add-In that will allow users, through different User
Forms, the ability to query information that is residing on an Access
Database. BUT the tables in the mdb are actually ODBC linked tables to
Oracle, IBM DB2, and SQL Server data. NONE of the tables in this database
where created, ALL are linked via ODBC.

When I build the User Form and run the code on my computer it works, but how
can I have other users be able to use the add-in and query the information in
my database when they don't have all the ODBC drivers or permission to these
ODBC tables? Is ADO the answer, or should I be using somthing else?

Also, can someone explain to me what a UDL file is and how to use it? Right
now I just "spell out" the connection in the VBE code.

Thanks!!!!

Excel Add-In Using ADO to retrieve database records
 

Thank you! Can you tell me a little more about DataFactory Objects? How do
I use this in the typical ADO code that you see out there? Can you post any
example code that you might have seen where someone is using this the same
way I intend to?

Thanks!!!!

"Karthi Ganesh" wrote:

Hi,

You try Remote Data Factory objects.

regards
Karthi Ganesh


"cg" wrote:

Hello All,

OK, I am a NOVICE at best with ADO 2.8 but am enjoying it immensely! Here
is what I am in need to help with...

I am designing an Excel Add-In that will allow users, through different User
Forms, the ability to query information that is residing on an Access
Database. BUT the tables in the mdb are actually ODBC linked tables to
Oracle, IBM DB2, and SQL Server data. NONE of the tables in this database
where created, ALL are linked via ODBC.

When I build the User Form and run the code on my computer it works, but how
can I have other users be able to use the add-in and query the information in
my database when they don't have all the ODBC drivers or permission to these
ODBC tables? Is ADO the answer, or should I be using somthing else?

Also, can someone explain to me what a UDL file is and how to use it? Right
now I just "spell out" the connection in the VBE code.

Thanks!!!!