"bhieb" <bh***@alanritchey.com> wrote in message
news:29**************************@posting.google.c om...
Alright this is a new one to me. I have linked a table using ODBC to
our AS400. When I either open it directly or query it I get the
incorrect values for several fields. For example the query on the
linked table returns these 5 records...
CUCUST CUALPH
0188 RITA
0188 RITA
0188 RITA
0188 RITA
0188 RITA
... But if I import the table then run the same query I get these
which are the corect values.
CUCUST CUALPH
0188 RITA
6188 RITA
7188 RITA
8188 RITA
9188 RITA
I am using Win 2k, Access 2002 w/ sp 2, IBM iseries Access for Windows
ver 5 rel 2 mod 0.
AS400 tables often do not have Primary Keys or Unique Indexes on them.
When you create the link you are then asked to identify a column or columns
that make up unique entries so that Access can build a local index for
doing updates.
You MUST either provide an accurate set of column names or hit [Cancel] so
that no index is created. If you select columns that do not in fact
constitute unique entries in the table then one of the side effects is what
you are seeing. Another (more dangerous) side effect is that when you edit
one row you will end up making changes in more than that row on the server.
Delete the link and then recreate it making sure to press [Cancel] at that
prompt and see if it makes any difference. If it does then see if you (or
someone else) can define a PK or Unique Index on the AS400 table and
recreate the link afterwards. Then you don't have to rely on the local
index which can be dangerous if you don't select accurately.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com