Source language: Translate to:

Large Fields in an Access Database

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Large Fields in an Access Database

Postby Enigman » Sat Mar 15, 2014 5:38 pm

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.
User avatar
Enigman
 
Posts: 314
Joined: Tue Apr 12, 2005 3:57 pm
Location: Foothill Ranch, CA

Re: Large Fields in an Access Database

Postby mishem » Sat Mar 15, 2014 11:16 pm

Memo? Blob (Picture)?
You can save data to a file and stored in the field Picture.
mishem
 
Posts: 575
Joined: Mon Oct 08, 2012 1:51 pm

Re: Large Fields in an Access Database

Postby Enigman » Sun Mar 16, 2014 12:28 am

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
User avatar
Enigman
 
Posts: 314
Joined: Tue Apr 12, 2005 3:57 pm
Location: Foothill Ranch, CA

Re: Large Fields in an Access Database

Postby Neosoft Support » Mon Mar 17, 2014 11:33 am

The memo field works well for large blocks of text.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests