Link Table in Access (1 Viewer)

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:


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? :banghead:

Thanks in advance,
Mapache

If you cross post --- put the same request in multiple forums, at least tell the reader you have done so.
cross posted at
http://www.accessforums.net/queries/oracle-link-table-query-30085.html

Please see:
http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

Sorry for that, It won't happen again.

Thanks,
Mapache

It isn't a "Don't Do It"

It's If you do do it, please tell us and point to the other thread.

You may get something from this video (no sound??)
https://www.youtube.com/watch?v=hxK1W0uDkX0&feature=related

Hi,

i'm doing that and it works fine but my problem is querying from another computer without the odbc driver.

i think you can do it with "ms remote" provider(point to my odbc driver) but i try to do it without success.

Any idea how to use ms remote???
mapache