Re: Attaching Remote Oracle Table in Access 2.0 with Update
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:
- 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-6032Received on Sat Oct 01 1994 - 23:38:33 CET