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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|