• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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
0
perennial
Asked:
perennial
  • 2
1 Solution
 
walterecookCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now