Solved

How to make a bigger field than Memo?

Posted on 2011-03-09
10
233 Views
Last Modified: 2012-05-11
HI

We need to store more characters that allowed by a memo field in access 97, is possible to do that?
0
Comment
Question by:dimensionav
10 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 35085957
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
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 35085965

 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
 

Author Comment

by:dimensionav
ID: 35086009
I want to store a big ammount of information, which is the description of a product
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 75
ID: 35086014
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
 
LVL 57
ID: 35086038
<<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
 
LVL 57
ID: 35086154
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
 
LVL 77

Expert Comment

by:peter57r
ID: 35093674
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35095795
^
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
 
LVL 75
ID: 35097067
@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
 
LVL 57
ID: 35097576
@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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question