I have been tring to update a table in Access 2010 from another table. Table A has a list of all our PCs on the network. TableA is missing information that TableB has, specifically LastLogonID, LastLogonDomain, and IPAddresses.
So here is the Code I came up with:
UPDATE TableA[All] AS A
INNER JOIN TableB AS B ON A.SystemName = B.SystemName
SET A.LastLogonID = B.LastLogonID, A.LastLogonDomain = B.LastLogonDomain, A.IPAddresses = B.IPAddresses;
It runs but nothing happens, can any help me out here. Am I trying to change to many fields?