UPDATE Query to Linked SQL2K Table

T

Tom Gaughan

Here's 2 update queries I'm running in Access.
The table called Amerisource is an Access2K table is the table being updated
The table called AHFS is a SQL2K table
The table called MDDBG is a SQL2K table (in another database than AHFS
table)

This query works:
UPDATE Amerisource INNER JOIN AHFS ON Amerisource.THERCLASS = AHFS.AH_THERCL
SET Amerisource.THERA_NAME = AHFS.AH_CLDESC

This query give the error "Operation must use an updateable query"
UPDATE Amerisource INNER JOIN MDDBG ON Amerisource.NDC_NO=MDDBG.G_NDC SET
Amerisource.GPI = MDDBG.G_GPI

I have system DSNs for the 2 SQL databases and can view their data in the
Access datasheet view...

Thanks for any help, Tom
 
Top