Fred,

You are going to need to use the fully qualified filename in your insert command.

scatter name oRecord MEMO FIELDS EXCEPT lot,location,location2
insert into <NetworkDriveLetter>\FolderName\veg from name oRecord
delete

So that VFP can find the file you want to insert into.