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

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
>
> PS: Access 2.0, ODBC 1.1, Oracle 7.1

Make sure the Oracle tables have unique keys identified in the table defs. Access can not get to the rowid pseudo column so it needs a specific key to update a record.
>
> PPS: While I'm at it : I posted the follwing in the word newsgroup but
> got no answer. I'm trying to access a oracle table from word using the
> wbodbc.dll from the word SDK ( word 6.0 ) and get a hang in SQLOpen.
> The ODBC driver would correctly ask me for user/pwd and then hang.
[Quoted] > Anyone any idea ?
Received on Thu May 22 1997 - 00:00:00 CEST