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
  #1  
Old September 4th, 2006, 11:03 PM posted to microsoft.public.access.gettingstarted
Reader1
external usenet poster
 
Posts: 11
Default Out of memory

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


  #2  
Old September 5th, 2006, 12:29 AM posted to microsoft.public.access.gettingstarted
J. Goddard
external usenet poster
 
Posts: 159
Default Out of memory

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 wrote:

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



  #3  
Old September 5th, 2006, 01:18 AM posted to microsoft.public.access.gettingstarted
Reader1
external usenet poster
 
Posts: 11
Default Out of memory


"J. Goddard" wrote in message
...
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.


  #4  
Old September 5th, 2006, 10:55 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Out of memory

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.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Reader1" wrote:

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



  #5  
Old September 5th, 2006, 11:10 PM posted to microsoft.public.access.gettingstarted
Reader1
external usenet poster
 
Posts: 11
Default Out of memory

"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.


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


  #6  
Old September 6th, 2006, 06:51 PM posted to microsoft.public.access.gettingstarted
DBS
external usenet poster
 
Posts: 50
Default Out of memory

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

"Reader1" wrote:

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



  #7  
Old September 11th, 2006, 04:05 PM posted to microsoft.public.access.gettingstarted
JornyO
external usenet poster
 
Posts: 7
Default Out of memory

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.
  #8  
Old September 11th, 2006, 04:21 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Out of memory

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JornyO" wrote in message
...
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.



  #9  
Old September 11th, 2006, 07:47 PM posted to microsoft.public.access.gettingstarted
JornyO
external usenet poster
 
Posts: 7
Default Out of memory

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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JornyO" wrote in message
...
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.




  #10  
Old September 11th, 2006, 07:54 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Out of memory

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JornyO" wrote in message
...
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" wrote:

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JornyO" wrote in message
...
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.






 




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 02:46 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.