UPDATE Query won't UPDATE! NO ONE CAN FIGURE THIS OUT!!!!

[kasimagj]

I'm trying to update 3 fields from the RANKS table into the RATES table, linking IDs as the unique identifier.



FOR SOME REASON, the result of running the query doesn't give the message: "ARE YOU SURE YOU WANT TO UPDATE..." instead it spits out a table (shown on the right) and doesn't have any fields.

If I flip the code to feed RATES into RANKS, it works perfectly...but that doesn't help me.

The RANKS table is a global table fed by an ODBC connection. That shouldn't affect it, but I'm totally clueless and have been trying to figure this out FOR WEEKS!!!!!!!!!!!!!!!!

PLEASE PLEASE PLEASE HELP ME, anyone!

UPDATE dbo_Bid_Rates
RIGHT JOIN dbo_bid_Ranks ON dbo_Bid_Rates.ID = dbo_bid_Ranks.ID
SET dbo_Bid_Rates.RATE_RANK = [dbo_bid_Rank].[RANK],
dbo_Bid_Rates.LC_CARR1 = [dbo_bid_Rank].[LC_CARR1],
dbo_Bid_Rates.LC_Carr2 = [dbo_bid_Rank].[LC_CARR2];


picture: https://docs.google.com/leaf?id=0B3M...3Yzg3&hl=en_US

[Stingaway]

Is your ODBC table in the background dependent or tied to any other table that would keep it from updating? In several of my ODBC databases I find that there are sometimes restraints placed upon tables that are linked to others in the backend database that I may or may not have access to in my front end linked to it.

[boblarson]

Yes, Stingaway is right. If you have an ODBC connected database then the table you want to update MUST have a primary key defined. If it doesn't, then it will not be updatable.