Page 1 of 1

Large Fields in an Access Database

PostPosted: Sat Mar 15, 2014 5:38 pm
by Enigman
Does anyone know how to define large fields in an MS Access database?

The largest field definition I can find in MS Access when creating a database is a text field of 255 characters. I would like to have a much larger text field for text in the 5K to 10K range. Obviously I could achieve that by spreading the text across multiple 255 character fields, but that's really uncomfortable to do.

I need to be able to store blocks of HTML code, so the best solution would be one large field.

Any pointers would be appreciated.

Thanks.

Re: Large Fields in an Access Database

PostPosted: Sat Mar 15, 2014 11:16 pm
by mishem
Memo? Blob (Picture)?
You can save data to a file and stored in the field Picture.

Re: Large Fields in an Access Database

PostPosted: Sun Mar 16, 2014 12:28 am
by Enigman
Unlike SQL databases, Access doesn't have BLOB fields "per se". It has OLE linking or embedding instead, which isn't really a text field type. I saw that before but didn't want to use it. But somehow I missed the "Memo" field type which allows 65,536 characters. I'll try that one.

Thanks for the pointer. :D

Re: Large Fields in an Access Database

PostPosted: Mon Mar 17, 2014 11:33 am
by Neosoft Support
The memo field works well for large blocks of text.