Can not View tables on Oracle 7.0...Help...Help...
Date: 26 Aug 1994 04:44:41 GMT
Message-ID: <33jrvp$958_at_cville-srv.wam.umd.edu>
I am using a combination of Oracle7.0 and MS-Access1.1. Recently, I
have exported a few tables to the Oracle server. The problem is that I
can not access any of these table on the server. The server shows me
those tables when I use "Select * from tabs", however, I can not use
any SQL command that will refer to these tables. Any reference to these
tables results in "table or view" does not exist error.
I tried to attach these tables to ACCESS, that lets me view these tables
but for some reason, in read-only mode. I tried to create a table on
Oracle server and then attaced them to ACCESS. In this case, ACCESS
even lets me modify these tables.
Summary of my questions is:
I will appreciate any help in this matter. BTW, I am using ODBC drivers
from Oracle to export these tables from ACCESS>
Thanks.