After some searching, it would appear this is because Access can only do one query at a time. Modified 6 years, 7 months ago. UPDATE myTable SET posX[id] = @arrayX[id], posY[id] = @arrayY[id] . I ...
When I learned about database structures (tables, records, keys) last time, the question of "how do you actually manipulate the data?" came up. In Excel, you can edit cells directly, but that is not ...