adding a field

[C.A. Amaya]

I would like a little help with a piece of code.
I have an Acess DB table, I want to add a field. My problem is that after
ading the field, the database is not updated. How do you add a field in an
existing table. thanks.

 

[Guest]

C.A. Amaya,

Use the Add Column clause of the Alter Table command:

http://msdn2.microsoft.com/en-us/library/aa140015(office.10).aspx

Kerry Moorman