Out of memory

[Reader1]

Hi

I've got a problem thats been bugging me for a while.

I'm the administrator with full rights of a database created in Access97

There are various forms and tables etc - all pretty standard stuff, there's
nothing fancy.

It's in a multiuser environment where the database is stored on a network
drive but the problem only affects me.

If I'm in a form (any form) and apply a filter, then either try to exit the
form or remove the filter and try to exit the form I get a message 'Out of
memory'

I can't duplicate it on the other users logins of whom none have admin
rights.

I replaced the PC last week for a brand new Dell model but I know the
previous PC had enough memory despite the message.

The new PC has 1GB of ram, its an Intel D processor.

The database is regularly compacted and its only 6MB in size.

Any pointers please as it's driving me nuts !!

Thank You

 

[J. Goddard]

Try running MS Access with no other applications running.

If that does not work, try deleting and re-installing MS Access (not the
..mdb database) on your new PC.

John

 

[Reader1]

Try running MS Access with no other applications running.

If that does not work, try deleting and re-installing MS Access (not the
.mdb database) on your new PC.

Thanks but the new PC obviously has a fresh install of MS Access

And yes I've already tried just running Access on its own but same error
message still.

 

[Jerry Whittle]

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.

Also you might have an app on your computer that is messing with Access or
is a big memory leaker. Also consider updating and running both your virus
and spyware checkers.

 

[Reader1]

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.

Also you might have an app on your computer that is messing with Access or
is a big memory leaker. Also consider updating and running both your virus
and spyware checkers.

No other large application software running and virus/spyware software is
constantly updated as it's a company PC



Thanks for the pointers

 

[DBS]

Believe it or not, you might have too MUCH memory!

There is a known bug with the 3.5 and earlier versions of the Jet database
engine, and it's easily resolved by downloading an update.

Check the following Knowledge Base article:

ACC: "Out of Memory" Error Starting Microsoft Access
http://support.microsoft.com/kb/161255/en-us

Hope that helps!

David

 

[JornyO]

I am having the same problem as well. I am running MS Access 2002 (with all
updates and patches installed) on a Pentium D 3.2 GHz processor with 3.25 GB
of RAM.

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.

 

[Douglas J. Steele]

Access 2002 certainly does still use the Jet Engine.

How large is your MDB file? Remember that there's a 2 Gb limit. When
changing data type, Access creates a new field, then deletes the old one.

 

[JornyO]

Hi Douglas,

My MDB file is 865 MB, so even doubling it puts it well under the 2 GB
limit. Is there anything in the Registry for the Jet Engine where I can
allow larger sizes of working files? One thing I had to do awhile ago was
increase the number of "locks per file" in the Registry from 9500 to 19500 to
get another query to work in a different database. Perhaps there's a similar
solution for this.

Bjorn

 

[Douglas J. Steele]

There's no way to get around the file size restrictions.

 

[John Vinson]

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]

 

[dbahooker]

Jet is alive and well and COMPLETELY OBSOLETE

Access Data Projects are a superior product, in performance, ease of
development and administration; deployment..

MDB is for retards and babies

 

[Reader1]

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

 

[John Vinson]

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]

 

[Reader1]

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

 

[John Vinson]

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]