MS Access 2002 - Text Field Size Limit

Hi all, I know this question is not directly related to the NT operating systems, but i hope it is ok to ask it here. This is just such a knowledgeable support group, I figured I'd get an snwer here.

Anyway, Access databases limit the size of text field to 255 charcaters. I need to know if there is a way around this limit, or if there is not, what is normally used for databases that require text field of much larger size.

I.E. what if I want to keep user comments on our website into a database, Access' 255 limit would not be enough.

We use the .Net technology for our site, so I would prefer to stay away from php/mysql combinations (I don't even know if mysql has the same limit or not)

Anyway, advice would be greatly appreciated.

Many thanks

Use a Memo field. The length is pretty much unlimited. Hit help and search for Memo field for details and gotchas ;-).

thank you so much!

Just remember that a memo field is not indexable (or at least it wasn't in Access 97).

And being unindexable it will most likely be useless for your purposes!
M$ wants you to buy SQl server!