Re: Opening Oracle Views from MS Access

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Mon, 05 Oct 1998 12:25:57 GMT
Message-ID: <3618ba02.3304050@newshost.us.oracle.com>

On Fri, 2 Oct 1998 15:52:31 -0700, "John F. Keaveney" <johnkeaveney_at_targusinfo.com> wrote:

>I have been unsuccessful in opening Views created in Oracle.
>I'm using Microsoft Access and I have created a link table to
>the Oracle view. Any thoughts?
>

What kind of problems are you encountering?

I just created a view FOOVIEW as SELECT ENAME, SAL FROM EMP in an Oracle8 8.0.5 database, connected to this database using Microsoft Access 97 and the Oracle8 8.0.5 ODBC driver from Oracle.

When I went to get external data and link a table, my view (FOOVIEW) appeared in my list of tables to link to. Attaching this view worked perfectly.

> Thanks,
> John
>

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Oct 05 1998 - 07:25:57 CDT