Problem updating Linked Oracle Tables in Access 2002

  • Thread starter Thread starter Harjinder
  • Start date Start date
H

Harjinder

Hi,

I am trying to update a linked table in Oracle from access
2002 and I cannot insert a record. Where as I can insert a
record in same table from Access 97. This table is owned
by the user I am connecting to , to create the linked
table.

If I link any other table in Oracle ( same schema and same
database) I can insert records for some and for some I
cannot. These are new linked tables I created on my
machine. Problem was reported by some other user.

Permissions are identical on all the tables. In fact the
user with which we are connecting to Oracle owns all these
tables.

thanks
 
Delete the link and re-create it.
If you are asked to provide a Unique Record Idenitifier, do so.

Un-updateability is usually caused by lack of a Primary Key or the
equivalent.

You may have to use a pseudo-index in Access to identify a unique record if
the above still fails.
You can create a "Fake" index in Access that tells Access which columns make
a Unique record in the linked table. The index is only used by Access is
completely unknown to the Server.

The following example creates an index on an ODBC linked table. The table's
remote database is unaware of and unaffected by the new index. The following
example won't work if you simply paste it into Microsoft Access; you first
need to create an ODBC linked table called OrderDetailsODBC.

(CREATE INDEX Statement in Help has some examples)

CREATE UNIQUE INDEX OrderID ON OrderDetailsODBC (OrderID);
 
Back
Top