Solved

Record not updateable

Posted on 2004-08-16
3
301 Views
Last Modified: 2008-02-20

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
Comment
Question by:perennial
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
walterecook earned 500 total points
ID: 11811170
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
 
LVL 17

Expert Comment

by:walterecook
ID: 11811187
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
 
LVL 1

Author Comment

by:perennial
ID: 11811211
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access / SQL Server - ODBC Problems 16 49
Format a text field as percent 12 53
Error 438 6 48
Importing specific cell from Excel to MS Access 17 42
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question