A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Out of memory



 
 
Thread Tools Display Modes
  #11  
Old September 12th, 2006, 12:23 AM posted to microsoft.public.access.gettingstarted
John Vinson
external usenet poster
 
Posts: 4,033
Default Out of memory

On Mon, 11 Sep 2006 08:05:02 -0700, JornyO
wrote:

The data base I am working with contains 5 tables, each with 30 fields (5
text (2 characters in length each) and 25 Numberic Long Integer). Each table
contains anywhere from 500,000 to 1.2 million records. When I add add about
4 more fields to each table using a macro, I get the 'ol "Out of Memory"
error (Microsoft ) can't change the data type. There isn't enough disk space
or memory." But this machine has 3.25 GB of RAM and a 230 GB Hard Drive!


The problem is that changing a table definition on a full table
requires that the ENTIRE TABLE be loaded into memory... twice, once
before and once after the change.

Instead, you can create the new table, empty, and run an Append query
to migrate the data into it. Then reset any relationships, delete the
old table, and rename the new one. Hint: MAKE A BACKUP first...

I looked into the earlier suggestion that it was an issue with the Jet
Engine, but accordingly to the literature I read, Access 2002 doesn't even
use the Jet Engine anymore. Any suggestions? Thanks.


The literature you read is in error. JET is alive and well in 2003. If
it was Aaron Kempf, he's a bit of a fanatic on the subject...

John W. Vinson[MVP]
  #12  
Old September 12th, 2006, 09:19 PM posted to microsoft.public.access.gettingstarted
Reader1
external usenet poster
 
Posts: 11
Default Out of memory


"Reader1" wrote in message
news
"Jerry Whittle" wrote in message
...


Believe it or not, it could be a network issue. Try plugging your
computer
into the network where you know another computer doesn't have the same
problem.


Thanks - I'll try that tomorrow.


Well I've tried all sorts and I still get the same message.

Funnily though the other users without full privileges don't get the error.

I can duplicate it on my login on any machine and surprise surprise, another
power user with same rights as me also gets the error message.

Any more tips ?

Thanks


  #13  
Old September 12th, 2006, 10:09 PM posted to microsoft.public.access.gettingstarted
John Vinson
external usenet poster
 
Posts: 4,033
Default Out of memory

On Tue, 12 Sep 2006 20:19:52 GMT, "Reader1" wrote:

I can duplicate it on my login on any machine and surprise surprise, another
power user with same rights as me also gets the error message.

Any more tips ?


Yes... posted yesterday. Here it is again:

The problem is that changing a table definition on a full table
requires that the ENTIRE TABLE be loaded into memory... twice, once
before and once after the change.

Instead, you can create the new table, empty, and run an Append query
to migrate the data into it. Then reset any relationships, delete the
old table, and rename the new one.


John W. Vinson[MVP]
  #14  
Old September 12th, 2006, 11:58 PM posted to microsoft.public.access.gettingstarted
Reader1
external usenet poster
 
Posts: 11
Default Out of memory

"John Vinson" wrote in message
...
On Tue, 12 Sep 2006 20:19:52 GMT, "Reader1" wrote:


Yes... posted yesterday. Here it is again:

The problem is that changing a table definition on a full table
requires that the ENTIRE TABLE be loaded into memory... twice, once
before and once after the change.

Instead, you can create the new table, empty, and run an Append query
to migrate the data into it. Then reset any relationships, delete the
old table, and rename the new one.


Err...........

Can't see how this applies to my original (first in thread) post John ????

Please re-read it. It's regarding filtering a form and trying to exit the
form.
That's when I get the Out of memory message.

Thanks


  #15  
Old September 13th, 2006, 12:41 AM posted to microsoft.public.access.gettingstarted
John Vinson
external usenet poster
 
Posts: 4,033
Default Out of memory

On Tue, 12 Sep 2006 22:58:41 GMT, "Reader1" wrote:

Can't see how this applies to my original (first in thread) post John ????


Sorry, it doesn't. Your thread got mixed with a thread from JornyO:

Please ignore my offtopic suggestion.

JornyO's message was:

The data base I am working with contains 5 tables, each with 30 fields
(5 text (2 characters in length each) and 25 Numberic Long Integer).
Each table contains anywhere from 500,000 to 1.2 million records.
When I add add about 4 more fields to each table using a macro, I get
the 'ol "Out of Memory" error (Microsoft ) can't change the data type.
There isn't enough disk space or memory." But this machine has 3.25
GB of RAM and a 230 GB Hard Drive!

I looked into the earlier suggestion that it was an issue with the Jet
Engine, but accordingly to the literature I read, Access 2002 doesn't
even use the Jet Engine anymore. Any suggestions? Thanks.


John W. Vinson[MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.