>Hi all,
>I'd like to add a field to the table using append method. How can I do this?
>I created the recordset, closed it and appended a field to it. Then I open the recordset and tried to assign the value to that field but the field was gone. I guess I have to update it first but the program did not let me update.
>Any help would be greatly appreciated.
>Thanks,
>Vivian

Here is a tiny snip from an alter I did to change a field. I believe that ALTER is right path for your solve as well

        cm1.ActiveConnection = cn1
        cm1.CommandType = adCmdUnknown
        cm1.CommandText = "ALTER TABLE C:\mydir\mytable.dbf ALTER COLUMN MyField c(4)"
        cm1.Execute