Chris

AUTOINCERROR off, will surely get you passed the read-only error message. However the Append From will renumber the records because of the autoinc set on the pk. That makes since, as you would want new records numbered during Append from. However, renumbering, backup versions not a good thing.

The next thought was to drop the pk (alter table DROP pk - dropping removes the index not the field) then Append from xxx, then put the primary key back together (alter table ADD pk) then AUTOIncError ON.

Problem, VFP gets confused, Append From xxx gives "File in use error".


Dallas