469,336 Members | 5,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,336 developers. It's quick & easy.

255 limit of field size

hi there

I'm creating a database site and using access. I've created a number of
fields i.e date, time, description, cost
The only problem is that the description info is larger than the 255
character limit imposed by access. How can I solve this one?

Thanks in advance
raj
Jul 19 '05 #1
2 4738
Either change the field type to memo or increase the size of the field

"raj chahal" <ra*@light-house.co.uk> wrote in message
news:ee*************@TK2MSFTNGP10.phx.gbl...
hi there

I'm creating a database site and using access. I've created a number of
fields i.e date, time, description, cost
The only problem is that the description info is larger than the 255
character limit imposed by access. How can I solve this one?

Thanks in advance
raj

Jul 19 '05 #2
The only way to pass the 255 limit in Access is to make it a memo
I would suggest using two tables linked with a key, separating the memo
field(s) from the other data. This will increase index performance and
querying on the data when the bucket gets large.

-dlbjr

invariable unerring alien
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by wing | last post: by
7 posts views Thread by johnm | last post: by
1 post views Thread by SpreadPeace | last post: by
3 posts views Thread by ken | last post: by
3 posts views Thread by Jefferis NoSpamme | last post: by
5 posts views Thread by Jefferis NoSpamme | last post: by
3 posts views Thread by John Taylor | last post: by
10 posts views Thread by =?Utf-8?B?UGFycm90?= | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
reply views Thread by Marylou17 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.