How to make a bigger field than Memo?

HI

We need to store more characters that allowed by a memo field in access 97, is possible to do that?
dimensionavAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
If you use VBA code to populate a Memo field, then you are only limited by the max size of the DB ... not the ~65K  if you manually populate a memo field.

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:

 Short answer is no.  You would need to split the field contents yourself and store in multiple fields.

 What is it your trying to accomplish?

JimD.
0
 
dimensionavAuthor Commented:
I want to store a big ammount of information, which is the description of a product
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Actually, the short answer is Yes.  From Help:

"Memo Lengthy text or combinations of text and numbers. Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.) "

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I want to store a big ammount of information, which is the description of a product >>

  And you need more then 64K of characters; that's one heck of a description!

JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Mx,

<<Actually, the short answer is Yes.  From Help:>>

  Technically yes, you can use AppendChunk() and GetChunk() to store more then 64k bytes of data, but then it's not exactly a "memo" field anymore.  You can't work with it directly in any real sense the way you would with other fields.  For example, try getting it onto a report.

  Of course splitting into multiple fields has some of the same issues, but then at least you can work with it through the UI to a certain extent.

  I took the question to mean in the context of dealing with regular fields through the UI.   What you suggesting is no different then sticking a file out on disk and reading that.   And actually, OLE linking to Word documents with the description might be a better idea.

JimD.
0
 
peter57rCommented:
Dimensionav
Sorry to be disbelieving but are you really sure this is what you want?

I can't imagine a situation where anyone would want to store 20+  A4 pages of unformatted text as a visible field in an Access database.
0
 
Jeffrey CoachmanMIS LiasonCommented:
^
Agreed, if you *truly* need this massive amount of text, then you may just want to store this in a Word Document and link/hyperlink to it from Access.

Awaiting your detailed explanation of this data...
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
@JDettman:

"Technically yes, you can use AppendChunk() and GetChunk()"

I'm not sure you need to use these just to write text >65K to a Memo field using VBA/DAO ...

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
@mx,

<<I'm not sure you need to use these just to write text >65K to a Memo field using VBA/DAO ...>>

  I don't know of any other way to do it other then that.

JimD.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.