Solved

Record not updateable

Posted on 2004-08-16
3
297 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
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

912 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now