Record not updateable


I have three tables; two are local, and one from the AS/400.

I link all these table in a query, and there is a message say that “Record not updatable”.

When I remove the table from the AS/400,  and leave the two local table it does allow me to change any record I want.

I do have permission to write to the AS/400 table. I will not let me update the record only when I connect these three tables together.

Explanation or help are much appreciated.

perennial
LVL 1
perennialAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
walterecookConnect With a Mentor Commented:
The fact that the table is AS400 is really a red herring.  The issue is the ability to update recordsets when there are 3 tables involved.  In short, it doesn't know what you want to update as the information could be from any of the three tables.

Walt
0
 
walterecookCommented:
It may or may not work, but ensure that you have the primary keys from each of the 3 tables included in the results, that could help.

Walt
0
 
perennialAuthor Commented:
Walt,

Is there a  way around this? I am using this  for a form, and I am trying to avoid a sub form if I can.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.