Hi,
I'm trying to work with an existing database table 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? I've read about switching from text to memo field data type, but I can't figure out how to switch. Also, will sql queries work once the change is implemented?
Thanks!