How to store large data in a database?

[ProgMan]

Hi everyone

I am trying to create a small application where I can store interesting articles and later retrieve those by selecting the topic. But I can't figure out how to save large data in a database since ms access only allows a max of 255 characters per field.

Can anyone please tell me how I can solve this problem?

 

[Stonkie]

The memo field type allows for very long textual values (I read it's up to 1GB here...).

 

[ProgMan]

Thank you very much Stonkie for your reply. I've been looking for this for quite some time but nobody told me about this memo field.

P.S. I've found out that memo field allows 65535 chars (though I need more space but for the time being much better then the text field ).

 

[cjard]

If you need more space than that, upgrade to a better DB