I almost never use a make table query - once in a great while I use one to not have to type all of the field names. (being lazy)
I do as June suggests - delete records and add new records.
Maybe you could post the dB? Change/Delete sensitive data first.