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: <3C5018E0.D7FDAE40@grenoble.cemagref.fr>

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
Received on Thu Jan 24 2002 - 08:23:28 CST