ALTER TABLE statement

[brenaaro]

Hi,

I have a database with a table (Sent) which contains a field (among others) called sntSubject. It is a text field of length 50.

I am trying to use an ALTER TABLE statement to set the length to 255 through VB referencing MS DAO3.6.

I create a database object, and use the DB.Execute method but I always get a Syntax error in my ALTER TABLE statements. Here is what I have tried:

ALTER TABLE Sent MODIFY sntSubject TEXT(255);

or

ALTER TABLE Sent MODIFY sntSubject CHAR(255);

but no luck. What would I need to do to make this work?

Thanks

[ralph]

try
ALTER TABLE Sent ALTER COLUMN sntSubject Text(255)

[brenaaro]

Beautiful! Thanks mate.

[Ephesians]

I'm getting a syntax error in this alter statement but I don't know what it is...

ALTER TABLE tblratesfromfeecard ALTER COLUMN [Capital Receipts Rate] text(255)