?
Solved

How to make a bigger field than Memo?

Posted on 2011-03-09
10
Medium Priority
?
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 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 58

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure 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 58
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 58
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 58
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

777 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