Re: Only read-only access to Oracle via ODBC and Access
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