Oracle to Access

  • Thread starter Thread starter hereisp
  • Start date Start date
H

hereisp

I have a linked table (Oracle) in my database. I wanted to display queried
data for people without MS Access. I can create Access Pages using the
tables local to the database and it works fine, but the when I use the linked
Oracle table the end user gets an error messages.

I have been given a username and password in order to link to the oracle
table. Do I need to install the ODBC driver on everyone's machine? Do I
also need to provide my username and password as I did in my link?

Thanks
 
Any user who opens the Access app on his/her workstation must have the
Oracle client tools installed in order to create a Data Source
Name/ODBC connection and must have a username/password valid for the
Oracle db that hosts the table(s) that are linked to the Access app.
 
Back
Top