ADO, RDO...How can I get users to access my information

[cg]

All,

I have an Access Database (mdb) that has tables linked to various servers
(Oracle, IBM DB2, SQL). Since I have the drivers and access to all these
servers I have no problem creating queries, etc. My ulitmate goal, however,
is to have others be able to view the queries that I am building or even
better queries they build using an Excel Add-In.

Question: How can I get my Excel Add-In to allow its user to access the
tables that reside on my Access database? I am using ADO and it works fine
on my machine, but when I test it on someone else's machine it errors out. I
think this is because they don't have the drivers or the access necessary to
view my tables in my Access database.

Help....

Thanks!!!

 

[Alex Dybenko]

Hi,
when you run query in access - it always runs on local machine under logged
user credentials. So you need all drivers installed and setup all DSN
entries on every PC you want to run these queries

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com