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