Re: 'Row cannot be located for updating...' error.
From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 12/15/04
- Previous message: William \(Bill\) Vaughn: "Re: Error "database placed in a state..." using ADO 2.7/2.8 in Acc"
- In reply to: shadow123: "Re: 'Row cannot be located for updating...' error."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 20:19:12 -0000
> I have also hit this problem, but I am unable to get this to work with
views
> as the problem persists. Does anyone have an example of how this is
supposed
> to work with views?
Are you selecting all PK fields for the underlying tables in your SELECT
(even if you are not interested in column for display purposes)?
I cannot see how ADO can update a row on a table if it cannot uniquely
specify that row (and the PK fields do exactly that).
Stephen Howe
- Previous message: William \(Bill\) Vaughn: "Re: Error "database placed in a state..." using ADO 2.7/2.8 in Acc"
- In reply to: shadow123: "Re: 'Row cannot be located for updating...' error."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|