SQL database field limited to 64 or 255 characters

[galapogos]

Hi,

I'm trying to work with an existing database with some fields already defined. One of them seems to be limited to only 64 characters, so when I try to insert a new item into that field, it gets truncated to 64 characters. I've tried deleting the column in Access and re-inserting a column, but it's limited to 255 characters too. The data I'm trying to store is a text string of 256 characters, so I'm 1 character short. Any ideas on how to increase the character limit?

Thanks!

[viperbyte]

Try using the memo datatype. It can hold 64000 characters.