It is possible that the column order was swapped in the source table. Access copies things like table structure when the link is first defined. Unless the links are refreshed, all kinds of strange things can happen when the source tables are modified later on.