how to UPDATE LINKED tables?

[Guest]

Friday, August 12, 2005 5:46 PM
--------------------------------------------------------

I have never been able to run a simple UPDATE query in my Access setup.
Here is what I get:

update TINWSF
set name = 'cliff-noronha--2005-08-09'
where Ltrim(rtrim(TINWSF.name)) is null

ERROR MESSAGE: OPERATION MUST USE AN UPDATEABLE QUERY

From reading a few posts, I have gathered that the culprit is the fact that
all my tables (including TINWSF) are actually linked to Oracle tables.

Which explains why it works in SQL+, which is not allowed where I work. Is
there ANY way that I can accomplish an UPDATE to a LINKED table in Access?

Please help. Thanks!

-- Cliff

-------------------------------------------------------------------------------

 

[Duane Hookom]

If you look at the table in design view, do you see any field or fields
marked as a primary key? If not, you can define one in Access with a data
definition query.

Another option is to use a pass-through query.

I'm not sure why you think you need to "trim" a field to check for null.

 

[Guest]

------------------------------------------------------------------------

Friday, August 12, 2005 8:46 PM

Duane,

Thanks, perfect! I trim because I want to update BLANKS as well as NULLS
all together. -- Cliff2noronha at gmail dot com