Re: In MS access: How to alter data in attached Oracle table ??
From: Deborah Luik <dluik_at_sr.csg.com>
Date: 1996/04/19
Message-ID: <slrn4ng7nk.b7n.dluik_at_raptor.sr.csg.com>#1/1
Date: 1996/04/19
Message-ID: <slrn4ng7nk.b7n.dluik_at_raptor.sr.csg.com>#1/1
On 17 Apr 1996 11:20:25 GMT, J,M.Whitehead <j.m.whitehead_at_shef.ac.uk> wrote:
>In article <316D1EE7.4253_at_cho.ge.com>, chris.little_at_cho.ge.com says...
>
>>I can't delete rows of data in the
>>table, however. The oracle owner can do all this in sqlplus, but
>>not in Access. Is there a setting in Access I need to adjust.
>
I ran into the same thing a while ago and remember experimenting.
If I remember correctly, Access will use Oracle's index if there is
one and the table is attached by its own name. However, Access is
not able to see that the index is there if the table is attached
via an Oracle synonym.
-- Deborah Luik, Lead DBA ADP Claims Solutions Group Phone: (800) 366-4237 x2150 2010 Crow Canyon Place FAX : (510) 866-4839 San Ramon, CA 94583 (USA) Email: dluik_at_sr.csg.comReceived on Fri Apr 19 1996 - 00:00:00 CEST