How do I get Access to see my Oracle tables. What, on Access, do a click?
The odbc driver seems to be set up.
> How do I get Access to see my Oracle tables. What, on Access, do a click?
> The odbc driver seems to be set up.
You need to set up an ODBC connection to your Oracle system using a valid
username and password. You do this by selecting "Link tables", then in the
file type drop-down select ODBC Databases(). You can then choose the data
source and supply the logon credentials.
HTH - Keith.
www.keithwilby.com
Brad Hall - 31 Jul 2006 18:51 GMT
> > How do I get Access to see my Oracle tables. What, on Access, do a click?
> > The odbc driver seems to be set up.
[quoted text clipped - 6 lines]
> HTH - Keith.
> www.keithwilby.com
Brad Hall - 31 Jul 2006 18:53 GMT
Related Question:
When I choose the ODBC() option in the dropdown, the dialog box goes away.
Any thoughts ?
> > How do I get Access to see my Oracle tables. What, on Access, do a click?
> > The odbc driver seems to be set up.
[quoted text clipped - 6 lines]
> HTH - Keith.
> www.keithwilby.com