>I am attempting to append records from a remote view where some of the records in the source table have Null values.
>
>Where all the values in a column are not null they import fine. But if some of the values in a column are Null then I get an error message e.g. 'Field2 does not accept Null values' .
>
>I have tried to look at the table designer and I can't see how to modify the structure to make the fields accept null values. All of the fields in the receiving table are character fields 30 characters wide.
>
>Mike Smith

You need to open table exclusively to be able to change NULL status using MODIFY STRUCTURE. You can also use ALTER TABLE command.