dimensionav
asked on
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?
We need to store more characters that allowed by a memo field in access 97, is possible to do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
"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
<<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.
And you need more then 64K of characters; that's one heck of a description!
JimD.
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.
<<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.
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.
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.
^
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...
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...
@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
"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
@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.
<<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.
ASKER