I've been through the list of potential reasons for a query being non-updateable. I cannot spot any reason.
twebrelay: Linked ODBC SQL Server table
has Primary Key
WebRelayID nvarchar(25), unique index, non null
CBWIdentifier nvarchar(25), unique index, non null
ztWebRelay: Local MS Access
has Primary Key
SerialNo short text (255) unique index non null
CBWID short text (255) unique index non null
There is no relationship between the tables. Thank you.
Code:
UPDATE twebrelay INNER JOIN ztWebRelay ON twebrelay.WebRelayID = ztWebRelay.SerialNo SET twebrelay.CBWIdentifier = [ztWebRelay].[CBWID];
twebrelay: Linked ODBC SQL Server table
has Primary Key
WebRelayID nvarchar(25), unique index, non null
CBWIdentifier nvarchar(25), unique index, non null
ztWebRelay: Local MS Access
has Primary Key
SerialNo short text (255) unique index non null
CBWID short text (255) unique index non null
There is no relationship between the tables. Thank you.