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!!!!