Re: Only read-only access to Oracle via ODBC and Access

From: Detlev Goebel <detlev.goebel_at_gzs.de>
Date: 1997/05/14
Message-ID: <3379BB8D.369C_at_gzs.de>#1/1


Gerold Krommer wrote:
>
> I'm sure I'm just doing something stupid.
>
> I try to access ( and modify ) rows in an Oracle database with ODBC. I
> can access it from odbctst.exe, MS-Query and a home grown VB app
> alright ( meaning I can read, insert, update ). It is only MS-Access
> which is giving me some headache.
>
> I can read the tables in Access but Access wouldn't allow me any
> updates. The corresponding menu entry ( 'allow update' ) is grayed
> ( or greyed, depending where you live ) out and whatever I tried it
> insists on read-only mode.
>
> The username I use for oracle has all privs as I can update tables
> with MS_Query using that account.
>
> I'm stumped.
>
> Thanks for any input,
>
> /gerold

Gerold,

we had this problem too. After re-installing the Oracle stuff in 'English' it worked. That means : After you typed in setup choose the English language for installation.

Hope this helps

Detlev

-- 
Detlev Goebel

detlev.goebel_at_gzs.de
********************
Received on Wed May 14 1997 - 00:00:00 CEST

Original text of this message