Let me add to the discussion above and say that access thinks you are trying to execute multiple SQL statement because of the ; in the middle of the string. Either remove it, or the rest of the string...



Good Luck