PinkPanther 0 Posted August 9, 2003 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 Share this post Link to post
jimf43 0 Posted August 9, 2003 Use a Memo field. The length is pretty much unlimited. Hit help and search for Memo field for details and gotchas ;-). Share this post Link to post
jimbo 0 Posted August 14, 2003 Just remember that a memo field is not indexable (or at least it wasn't in Access 97). Share this post Link to post
duhmez 0 Posted December 29, 2003 And being unindexable it will most likely be useless for your purposes! M$ wants you to buy SQl server! Share this post Link to post
