Adding fields to an existing Access Database

[kenkofi]

I am trying to add a field to an existing Access database using:

revExecuteSQL tConnectionID,"ALTER TABLE UserData ADD COLUMN CustomerEmail TEXT(25)"

Nothing seems to happen and no error is generated. I read somewhere that you can only do this using DAO command CreateField.

Does anyone have any idea what the syntax is and how it can be done.

Any help is much appreciated.