Jump to content
Compatible Support Forums
Sign in to follow this  
PinkPanther

MS Access 2002 - Text Field Size Limit

Recommended Posts

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

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

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

Share this post


Link to post

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×