MS Access 2002 - Text Field Size Limit
This is a discussion about MS Access 2002 - Text Field Size Limit in the Windows Software category; 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.
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
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
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Responses to this topic
Use a Memo field. The length is pretty much unlimited. Hit help and search for Memo field for details and gotchas ;-).
OP
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!
M$ wants you to buy SQl server!
