Thing is, Access does not behave as MS SQL Server. I had to update recently a dBaseIV database with another (don't ask...) and the easiest way I could think of was Access.
I am no SQL Guru, but I remembered that in SQL Server you could do that:
I think this is a MS SQL Server specific syntax though...
However, in Access, you have to do that (I did not guess, I want through hope, denial, despair and finally to microsoft and had a look at the code generated):
Where source column was actually written as
I haven't tried to see what you got if you removed the brackets.
I am no SQL Guru, but I remembered that in SQL Server you could do that:
UPDATE target
SET target.column = source.column
FROM table1 target
INNER JOIN table 2 source
ON target.rel = source.rel
I think this is a MS SQL Server specific syntax though...
However, in Access, you have to do that (I did not guess, I want through hope, denial, despair and finally to microsoft and had a look at the code generated):
UPDATE target
INNER JOIN table 2 source
ON target.rel = source.rel
SET target.column = source.column
FROM table1 target
Where source column was actually written as
[source]![column].I haven't tried to see what you got if you removed the brackets.
Leave a comment