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 |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|