>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
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams