Overcome Access Memo size limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have any ideas how I can get around this problem ?

The Memo field allows 65,535 strings of character input, but what happens
after I have reached that plateau? Is there a way I can over come this size
limit ?
 
You can use an OLE Object to store/retrieve binary data, using VBA DAO or
ADO code. The AppendChunk method, not surprisingly, appends a chunk of
binary data to the OLE Object and the GetChunk method gets a chunk of binary
data from the OLE Object. If memory serves, working from code, you can
actually exceed the stated limits for Memo fields, as well.

Perhaps I am being dense, but 65,536 characters seems more than plenty of
text to store in a database field that will either be displayed on-screen or
printed. If I am storing more text than that, I'll want it broken down into
smaller, more usable pieces that are easier to search, locate, and use.

You can also, if you wish, store text data in an external file and use
Access' FileI/O or the FileSystemObject to save, access, and manipulate it.

Larry Linson
Microsoft Access MVP
 
On Fri, 10 Mar 2006 18:23:27 -0800, Bluefin Tuna <Bluefin
Does anyone have any ideas how I can get around this problem ?

The Memo field allows 65,535 strings of character input, but what happens
after I have reached that plateau? Is there a way I can over come this size
limit ?
Click to expand...

The limit is actually 2 GByte (and it's limited by the .mdb file
container, not the field per se). You do need to use VBA code to
populate it; the 65k limit is not on the field but on the Textbox form
control bound to the field.

Is someone *really* going to sit down at a terminal and type 65KBytes
into a textbox!? That's about 30 typed pages. What are you storing in
this field?

John W. Vinson[MVP]
 
I was wondering about this issue myself. My Sister is a remedial therapist
and needs to write down what the persons injuries are , how they did it , and
then what we did to them to ttry and fix the issue and if she has a client
that attends to her weekly for an ongoing problem she needs the room to type
to.
 
I was wondering about this issue myself. My Sister is a remedial therapist
and needs to write down what the persons injuries are , how they did it , and
then what we did to them to ttry and fix the issue and if she has a client
that attends to her weekly for an ongoing problem she needs the room to type
to.
Click to expand...

In a database, I'd really very strongly suggest NOT putting all this
information into a single record, much less a single memo field.

If a Patient has multiple Injuries, there's a one to many relationship
(one patient to multiple injuries). If each injury needs several
treatments, there's another one to many relationship. Each Treatment
should be in a separate record (with ClientID, InjuryID, TherapistID,
TreatmentDate, and then a memo field for the notes about *THAT DAY'S
TREATMENT*. Storing the entire treatment history in a single memo
field might be tempting but it's not making proper use of Access!

John W. Vinson[MVP]
 
John Vinson said:
Storing the entire treatment history in a single memo
field might be tempting but it's not making proper use of Access!
Click to expand...

And it would be easy to hit a single keystroke and remove the entire
contents of that memo field. <shudder>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
i really no idea
John Vinson said:
On Fri, 10 Mar 2006 18:23:27 -0800, Bluefin Tuna <Bluefin


The limit is actually 2 GByte (and it's limited by the .mdb file
container, not the field per se). You do need to use VBA code to
populate it; the 65k limit is not on the field but on the Textbox form
control bound to the field.

Is someone *really* going to sit down at a terminal and type 65KBytes
into a textbox!? That's about 30 typed pages. What are you storing in
this field?

John W. Vinson[MVP]
Click to expand...
 
Back
Top