I am trying to run an update query (part of an Access form) against a table that is linked to the MDB from an Oracle database. The idea is to populate one column of the Oracle table with a constant value throughout.
Unfortunately, this has to be done from the Access end – doing it in SQL*Plus or something like that is not an option for developmental reasons (end users need to do the whole shebang through an Access form).
The syntax would seem simple enough:
UPDATE [WQ DATA]
SET PROJNUM = ‘WQ1958001’
WHERE PROJNUM is NULL;
But no – Access returns an error that a “single-row update is being applied to multiple rows. Unique index contains duplicate records.”
OK, so WTF? The Oracle table has no contraints or indexing. And why does Access think this is a single-row update when the query clearly is meant to update all the rows in the table?
Thanks in advance for any advice.