MS-Access /Oracle ODBC problem

From: Rajib Ghosh <rghosh_at_ix.netcom.com>
Date: 1996/01/04
Message-ID: <4ch1bo$9dg_at_ixnews4.ix.netcom.com>#1/1


I am running MS-Access 2.0 with Local Personal Oracle 7.1.4 and remote Oracle 7.1.6 versions thru SQL*Net version 2.1.

Here is what happens when I try to attach an Oracle table in Microsoft Access.
Access and Personal Oracle :
I can successfully attach an Oracle table (created thru sql*plus ) and can view the data. I cannot do any insert , update or delete from microsoft access on the table.
Under the same user I have some tables created by a case tool called S-designor. When I attach these tables in MS-access , I can do any operations (i,e insert,update,delete,select).

Access and remote Oracle 7.1.6 :

For a particular Oracle user ( say "opeds143b" ) I can do select,update,insert,delete on all the tables after attaching the table in MS-Access without any problem.
For tables of all other Oracle users , I get the following MS-Access Error :
Reserved Error[-1310];there is no message for this error.

The same problem exists while trying to connect into Oracle with Visual Basic.

Can anybody throw some light into this problem?

Thanks
Rajib Ghosh
rghosh_at_ix.netcom.com
(303)-914-4370 Received on Thu Jan 04 1996 - 00:00:00 CET

Original text of this message