473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access 'there isnt enough memory' when scrolling textbox

I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.

Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.

Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?

Thanks in advance,
Robert Waters
Jun 27 '08 #1
7 2862

"robert.waters" <ro***********@gmail.comwrote in message
news:3e**********************************@m44g2000 hsc.googlegroups.com...
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.

Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.

Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?

Thanks in advance,
Robert Waters
Windows has or had a limit on resource memory, controls on a form like combo
box and text box's use this limited memory. Anyway you can format the data
into a table format? Scrolling a sub-form record by record should not cause
a problem.
Jun 27 '08 #2
On Jun 23, 1:35*pm, "paii, Ron" <n...@no.comwrote:
"robert.waters" <robert.wat...@gmail.comwrote in message

news:3e**********************************@m44g2000 hsc.googlegroups.com...
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. *I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.
Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. *The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). *It seems like Access is hitting a wall
somewhere.
Is there another textbox-like control that will accept more data? *I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? *Any solutions?
Thanks in advance,
Robert Waters

Windows has or had a limit on resource memory, controls on a form like combo
box and text box's use this limited memory. Anyway you can format the data
into a table format? Scrolling a sub-form record by record should not cause
a problem.
Unfortunately, the data is basically the contents of large text files
that I have put into the database and indexed (FULLTEXT) for
searching. This wouldn't be able to be presented inside of a
datasheet, unless I could programmatically resize a table cell, and
place a scrollbar inside of a table cell.

Is it possible to load a small chunk of the data into the textbox at
first, and then successively load more data/remove old data based on
how the user is scrolling?
(like how dzone.com loads more content as the user scolls, effectively
displaying all possible data on the first page.)
Jun 27 '08 #3
robert.waters wrote:
On Jun 23, 1:35 pm, "paii, Ron" <n...@no.comwrote:
>>"robert.waters" <robert.wat...@gmail.comwrote in message

news:3e**********************************@m44g20 00hsc.googlegroups.com...

>>>I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.
>>>Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.
>>>Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?
>>>Thanks in advance,
Robert Waters

Windows has or had a limit on resource memory, controls on a form like combo
box and text box's use this limited memory. Anyway you can format the data
into a table format? Scrolling a sub-form record by record should not cause
a problem.


Unfortunately, the data is basically the contents of large text files
that I have put into the database and indexed (FULLTEXT) for
searching. This wouldn't be able to be presented inside of a
datasheet, unless I could programmatically resize a table cell, and
place a scrollbar inside of a table cell.

Is it possible to load a small chunk of the data into the textbox at
first, and then successively load more data/remove old data based on
how the user is scrolling?
(like how dzone.com loads more content as the user scolls, effectively
displaying all possible data on the first page.)
Is the data that you want to see going to be modified? Or viewed only?
Do you have lots of these big memos?

Maybe you could check the size of the memo field. If it's less than n
number of bytes (I'll assume you know about how many) then present it in
an unbound text box. If over the n byte limit, send the output to a
text file and enter something like "Memo to large to fit. Dbl-Click to
view". Then write the memo out to a doc file and open it in Word or
WordPad.

Jun 27 '08 #4
There is a 64KB limit when the user interaction with the control is
required. This is an old GDI WIndows limitation linked to the 64KB limit of
the ScrollBar control.

Other than cutting your data up into manageable chunks, you could use the
RTF control on my site that you mentioned failed. You just have to set the
MaxCharsAllowed property in the Load event of the form containing the
control. I think I maxed this value out at 1000KB.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"robert.waters" <ro***********@gmail.comwrote in message
news:3e**********************************@m44g2000 hsc.googlegroups.com...
>I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.

Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.

Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?

Thanks in advance,
Robert Waters

Jun 27 '08 #5
Thank you Mr. Lebans. I think I might have figured out why it
wouldn't work.
The RTF control displays nothing at all, but when I print something
like mid(rtfcontrol.value,1,50) to the immediate window, I see the
data.
Do control characters (\t, \n et al) mean anything special in rtf-
speak? They might be suppressing the output...

On Jun 23, 9:33*pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@linvalid.comwrote:
There is a 64KB limit when the user interaction with the control is
required. This is an old GDI WIndows limitation linked to the 64KB limit of
the ScrollBar control.

Other than cutting your data up into manageable chunks, you could use the
RTF control on my site that you mentioned failed. You just have to set the
MaxCharsAllowed property in the Load event of the form containing the
control. I think I maxed this value out at 1000KB.

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"robert.waters" <robert.wat...@gmail.comwrote in message

news:3e**********************************@m44g2000 hsc.googlegroups.com...
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. *I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.
Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. *The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). *It seems like Access is hitting a wall
somewhere.
Is there another textbox-like control that will accept more data? *I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? *Any solutions?
Thanks in advance,
Robert Waters
Jun 27 '08 #6
You cannot insert plain text when the control requires RTF encoded text.

Use an Unbound RTF2 control.
In the Current event of the form hosting the RTF2 control do something like:
Me.NameOfUnboundRTF2Control.PlainText =
Me.NameOfYourTextBoxBoundToYourMemoFIeld.Value

Check the PlaintText property name(RTF2 control -Properties and make sure
I spelled it correctly.

If you want to control the RTF Header and Footer you must prepend/append to
your plain text string then see the code/logic in this post:

..

The RTF control can only display RTF encoded text. If you want to simply
display plain text then wrap your plain text within the required RTF
encoding.
Here's a previous post of mine on a related issue.
http://groups.google.ca/group/micros...orms/browse_fr...
From: Stephen Lebans - view profile
Date: Tues, Feb 14 2006 9:30 pm
Email: "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
Groups: microsoft.public.access.forms
Not yet ratedRating:
show options
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse | Find messages by this author
Let me know how you make out.
Make sure your Form has:
A TextBox control named txtComment bound to the Comment field(just o you can
see the RTF encoding)
an RTF2 control bound to the Comment field
A CommandButton named cmdRTF
In your References, make sure the ref to DAO is higher in the list than ADO.
Place this code behind the Command Button.
Private Sub CmdRTF_Click()
On Error GoTo Err_CmdRTF_Click
Dim sRTFdata As String
Dim sHeader As String
Dim sText As String
sHeader =
"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttb l{\f0\fnil\fcharset0
Arial;}}"
sHeader = sHeader & "{\colortbl
;\red0\green0\blue0;}\viewkind4\uc1\pard\cf1\fs24"
' I could have shortened the code but I wanted you(and others I refer to
this posting) to see what is happening at every step.
With Me.RecordsetClone
' Move to first record
.MoveFirst
' Loop until all records are processed
' This example uses a field named "Comment"
' Note this is the name of the FIELD not the
' name of the TextBox control bound to this field
Do While Not .EOF
.Edit
sText = IIf(IsNull(.Fields("Comment")), "", .Fields("Comment"))
' See if field is empty
If Len(sText & vbNullString) = 0 Then
sRTFdata = sHeader & "}"
Else
sRTFdata = sHeader & sText & "\par }"
End If
' Save our RTF encoded string back to Comment field
.Fields("Comment") = sRTFdata
.Update
' Move to next record
.MoveNext
Loop
End With
Exit_CmdRTF_Click:
Exit Sub
Err_CmdRTF_Click:
MsgBox Err.Description
Resume Exit_CmdRTF_Click
End Sub

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"robert.waters" <ro***********@gmail.comwrote in message
news:f0**********************************@y21g2000 hsf.googlegroups.com...
Thank you Mr. Lebans. I think I might have figured out why it
wouldn't work.
The RTF control displays nothing at all, but when I print something
like mid(rtfcontrol.value,1,50) to the immediate window, I see the
data.
Do control characters (\t, \n et al) mean anything special in rtf-
speak? They might be suppressing the output...

On Jun 23, 9:33 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@linvalid.comwrote:
There is a 64KB limit when the user interaction with the control is
required. This is an old GDI WIndows limitation linked to the 64KB limit
of
the ScrollBar control.

Other than cutting your data up into manageable chunks, you could use the
RTF control on my site that you mentioned failed. You just have to set the
MaxCharsAllowed property in the Load event of the form containing the
control. I think I maxed this value out at 1000KB.

--

HTH
Stephen Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"robert.waters" <robert.wat...@gmail.comwrote in message

news:3e**********************************@m44g2000 hsc.googlegroups.com...
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.
Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.
Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?
Thanks in advance,
Robert Waters

Jun 27 '08 #7
It worked, well. Thank you.

I sandwiched the data between valid RTF codes (per your example), and
displayed it using the PlainText property of the RTF control.
All I need to do is run a regex to replace valid characters with their
RTF equivalents (\ldblquote et al), and it will have completely solved
my problem.

Thank you,
Robert Waters
Jun 27 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: George Hester | last post by:
Please take a look at this google artcle: http://groups.google.com/groups?hl=en&lr=&frame=right&th=55d6f4b50f5f9382&seekm=411f370d%241%40olaf.komtel.net#link9 The op was having trouble with...
3
by: hippo | last post by:
trying to get some old stuff off an old database. installed access 97,yes access 97. on a W2K, update4 machine with 500mg ram. ALL other programs run great. i get: 'out of memory' "A system error...
10
by: B Moor | last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM SQL Server 2000 sp3 (or latest).MS Office 2k3 I have the access 2k3 front end running on server (this may get changed) and all was well...
1
by: B Moor | last post by:
Hello, I am quite bogged down with this problem and would like some tips/help if any one has any. Thanks in advance. The Problem ----------- This system initially seemed quite stable for...
24
by: David Mathog | last post by:
If this: int i,sum; int *array; for(sum=0, i=0; i<len; i++){ sum += array; } is converted to this (never mind why for the moment):
12
by: VMI | last post by:
For some reason, the process of retrieving data (about 20 records) from an Access table that has 400K records to a dataTable is taking over 3 mins. to complete. Below is my code to connect to the...
3
by: Kza | last post by:
Hi, I am currently using xerces sax parser for c++, (I use DOM too, but I think SAX is more relevant here) for processing and displaying fairly large xml files. Usually I give xerces a filename,...
10
by: WannaKatana | last post by:
I am just wondering why, with nothing else running and executing an update query against a very large table, does Access seem to be causing less than 10% processor usage. Then it says "There is not...
1
by: JOCOPVA | last post by:
i try to open up microsoft access 2003 and i get an error message it reads A system error occurred, or there isnt enough free memory to start. Close unneeded programs and tyry again. I have...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.