ALTER TABLE statement

[jal]

I tried:

ALTER TABLE groupids ADD COLUMN groupid TEXT

But when I poll for the datatype I get "Memo". This datatype will cause me problems because Jet won't let me inner join on Memo fields. I need TEXT field. I tried "Alter Column GroupID Text" but it remains Memo (no error throws).

I am executing these queries using an AccessViewer package (I don't have Access installed).

 

[jal]

Solved - you have to put a limit on it

TEXT (255)