I've been trying to update a table within the financial system we use by running a number of different queries and vice-versa for a while. I can open the destination table in access 2010 and edit it "on-the-fly" so permissions and connection issues shouldnt be the problem.
I've also managed to...