Access and Iseries

  • Thread starter Thread starter Antonio Stroman
  • Start date Start date
A

Antonio Stroman

Hello all, I'm trying to create an update query in Access that will update a
linked table that I have on the 400. I'm using the ODBC driver supplied with
client access version 5.2. The problem that I'm running into is that when
trying to do the update I get the message that my table is not an updateable
query.

I believe there is a way for me to update the query without importing the
table but not 100% sure. Any help would be appreciated.
 
Antonio Stroman said:
Hello all, I'm trying to create an update query in Access that will update a
linked table that I have on the 400. I'm using the ODBC driver supplied with
client access version 5.2. The problem that I'm running into is that when
trying to do the update I get the message that my table is not an updateable
query.

I believe there is a way for me to update the query without importing the
table but not 100% sure. Any help would be appreciated.
Click to expand...

If the table has no Primary Key or Unique Index on the Iseries, then a link
will normally be read only.

When you create the link you should be prompted to provide the column or
columns Access can use to build a local index on and then updates will be
possible. Be careful though that you choose columns that actually do
comprise fields with no duplicates in the table. If you choose columns
that actually have some duplicates then updates to one of those rows will
be propagated to ALL of the duplicate rows as well.

If you have the ability, I would actually add the PK or Unique Index to the
table on the Iseries and then recreate the link. That is the safest way to
proceed.
 
Back
Top