oracle Link table query

[mapache]

Hi All,



In my access i have a link table (oracle) and i can do queries from my computer cause i have the driver installed.
Ex:

 select distinct dept from [ODBC;DSN=dsn;server=server.com;uid=user;pwd=password].table_name

i'm doing this query to enter the username and password by query.
My problem is when someone (in other computer) query the access they need to have the driver installed(the only way that i know is to install client oracle wich is a bit heavy).

I tried with "MS Remote" without success.
Does anyone know how it works the ms remote provider? or if you know a better solution?"

Thanks in advance,
Mapache

[mapache]

FYI,
I cross posted this topic in another forum...

http://www.access-programmers.co.uk/...57#post1209357

Thanks,
Mapache