[Q] How to change a field in table (Access 2000)

[White_Rose]

I use the following SQL:
ALTER TABLE MEMBERS MODIFY m_password TEXT(32)
but I get a error: "Error syntax..."
And then, I try with
ALTER TABLE MEMBERS MODIFY m_password CHAR(32)
but i still get the same result

How i have to do?

sorry because of my english :D

[quaitieutu]

ALTER TABLE MEMBERS MODIFY m_password TEXT(32) u have to enter the mdifying attribute which is m_password
Good luck:rolleyes: :D :) lol

[White_Rose]

I think that TEXT(32) is the attribute i want to change.

[White_Rose]

hu hu hu...
the answer is:
ALTER TABLE MEMBERS ALTER COLUMN m_password VARCHAR(32)