Re: Attaching Remote Oracle Table in Access 2.0 with Update

From: Frank Greene <75144.347_at_CompuServe.COM>
Date: 1 Oct 1994 22:38:33 GMT
Message-ID: <36kod9$on9$1_at_mhadf.production.compuserve.com>


My experience is that in order to update an Oracle table attached to Access, you need to do two things within Oracle:

  1. Create a unique index on the Oracle table

        Create unique index index1 on the_table (col1, col2)

2. Identify the index as the primary key

        Ater table the_table add(primary key (col1, col2))

hatchg_at_neosoft.com writes:
> > steveh_at_devildog.att.com (Steve Hendershott) writes:

> > I have an ORACLE 7 database on UNIX running SQLNET over TCP. I have Access
> > 2.0 on my Windows Client. I attach the ORACLE tables to an Access database.
> > The indexes that are in ORACLE do not appear in the attached table and
> > therefor I can not update the table. I can creat a unique index on Access,
> > but why does it NOT see the index that exists in the ORACLE database?
> >
> > Thanks for any help,
> >
> I use Access 2.0 to connect to an Oracle7 DB as well. As long as I have a UNIQUE index on my Oracle table, I can update
> via Access. However, if you created the unique index after attaching the table, make sure to either drop and reattach the table
> or refresh the attachment.
>
> >>>>
>
>
>
> Greg Hatch
> hatchg_at_neosoft.com
>

-- 
Specialists in Relational Technology
Knoxville, Tn
[615]458-6032
Received on Sat Oct 01 1994 - 23:38:33 CET

Original text of this message