REPOST: Re: Updating an Oracle DB from MS Access

From: Burnet Roland <roland.burnet_at_grenoble.cemagref.fr>
Date: Thu, 24 Jan 2002 15:23:28 +0100
Message-ID: <1$--$%%%%--%_--$_$@news.noc.cabal.int>

Thanks for your reply.
In fact the problem was :
1) an Oracle table without a primary key 2) an ODBC configuration set to read-only Now it is OK

Thanks again

R. Burnet

Burnet Roland wrote:
>
> Hi,
> Before developing an applet to update an Oracle 8.1.7 data base, we want
> to fill and update it from MS Access 2000.
> I have tried to create a link in MS Access to an Oracle table via ODBC,
> there is no problem, but I am unable to insert or modify any record.
> Where is the solution ? Access or Oracle side ?
>
> Thanks in advance
>
> R. Burnet

WAS CANCELLED BY =======: From: Burnet Roland <roland.burnet_at_grenoble.cemagref.fr> Control: cancel <3C5018E0.D7FDAE40_at_grenoble.cemagref.fr> Subject: cmsg cancel <3C5018E0.D7FDAE40_at_grenoble.cemagref.fr> Date: Mon, 28 Jan 2002 01:49:37 GMT Message-ID: <cancel.3C5018E0.D7FDAE40_at_grenoble.cemagref.fr> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newshub2.rdc1.sfba.home.com!news.home.com!peer1-sjc1.usenetserver.com!usenetserver.com!gestalt.direcpc.com!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716533

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 08:23:28 CST