database store!
-
hi, how can i expand the 255 words for the microsoft access database. because i need to enter more words than 255. how can i?? thanks!
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
Slow down and explain what you mean.
only two letters away from being an asset
-
Slow down and explain what you mean.
only two letters away from being an asset
-
as you know .. the microsoft access allows only length of 255 words maximum. now how can i expand that into a larger scale?? :(
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
ADY007 wrote:
microsoft access allows only length of 255 words maximum
Does it? What specifically does it limit to 255 words? Couldn't you get around it by putting underscores between the words so it wouldn't see them as separate words?
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
ADY007 wrote:
microsoft access allows only length of 255 words maximum
Does it? What specifically does it limit to 255 words? Couldn't you get around it by putting underscores between the words so it wouldn't see them as separate words?
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
Thanks for your help buy what could i gain if i make the underscores? the problem is that the access cannot allow over than 255 words in one time :(. The member cannot write over than 255 words :(. I think mysql is better than access ey??
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
-
Thanks for your help buy what could i gain if i make the underscores? the problem is that the access cannot allow over than 255 words in one time :(. The member cannot write over than 255 words :(. I think mysql is better than access ey??
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
ADY007 wrote:
what could i gain if i make the underscores?
You just insert one big word instead of lots of little words. Then you have no limit! However, I really think that "words" is incorrect. I don't know what you mean, but I am pretty sure that Access has no limit to the number of "words". Also, you didn't say where these "words" were within Access? So that removes a some context from which I could possibly figure out what you mean.
ADY007 wrote:
I think mysql is better than access ey??
I couldn't say. I don't particularly have any strong opinions about either.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
ADY007 wrote:
what could i gain if i make the underscores?
You just insert one big word instead of lots of little words. Then you have no limit! However, I really think that "words" is incorrect. I don't know what you mean, but I am pretty sure that Access has no limit to the number of "words". Also, you didn't say where these "words" were within Access? So that removes a some context from which I could possibly figure out what you mean.
ADY007 wrote:
I think mysql is better than access ey??
I couldn't say. I don't particularly have any strong opinions about either.
Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
i mean .. letters not words sorry .. my mistake. I just check ms access and when i go to the design mode of the database, for the ItemDescription for example .. its telling me that the Field Size is 255 and when i try to make it bigger it dont want to maximize it. :(
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
-
i mean .. letters not words sorry .. my mistake. I just check ms access and when i go to the design mode of the database, for the ItemDescription for example .. its telling me that the Field Size is 255 and when i try to make it bigger it dont want to maximize it. :(
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
Nope. A field in Access with a "text" datatype is limited to 255 characters maximum. For more characters than that, you can use the "memo" datatype.
-
hi, how can i expand the 255 words for the microsoft access database. because i need to enter more words than 255. how can i?? thanks!
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
ADY007 wrote:
hi, how can i expand the 255 words for the microsoft access database. because i need to enter more words than 255. how can i??
Assuming you are refering to the max column size of a Text field in Access. If you want more than 255 characters then you'll need to use a memo field instead.
Michael CP Blog [^] Development Blog [^]