473,320 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Out of memory error Access 97/XP Home with > 512 megs of RAM

Access 97 is running on an XP Home machine pulling up a database on an
XP Pro machine. The XP Home machine has 512 megs of RAM, the XP Pro
machine has 768 megs. Access 97 runs fine on both machines. However,
when I recently tried to add another 256 megs of RAM to the XP Home
machine, I can't even load Access. I get an "out of memory" error,
"close unneeded programs and try again". The rest of my Office 97
apps work fine with the extra RAM, and I've tried about 4 different
sticks or RAM, switching slots, etc. As soon as I go back to 512
megs, it works fine again. I've tried uninstalling/reinstalling it
too. Meanwhile, the same app works fine on XP Pro with 768 megs of
RAM. I've also tried running it in '95 and '98 compatibility modes.
It doesn't seem to be a network thing because the out of memory errors
come up extremely fast, before it can start looking on the LAN for the
db.

I saw something about there being similar problems with Windows 98,
changing the VCACHE value to fix it, but not with XP Home. I
downloaded SR1 and some other updates for Office 97, but haven't
installed them yet as they were released before XP came out. Of
course the Win2k update might work fine on XP. But the XP Pro machine
is running Access 97 without any updates.

Richard Turner
Nov 12 '05 #1
1 10775
On Thu, 11 Dec 2003 11:31:19 -0500, richard turner <rt*****@ecg.com>
wrote:
Access 97 is running on an XP Home machine pulling up a database on an
XP Pro machine. The XP Home machine has 512 megs of RAM, the XP Pro
machine has 768 megs. Access 97 runs fine on both machines. However,
when I recently tried to add another 256 megs of RAM to the XP Home
machine, I can't even load Access. I get an "out of memory" error,
"close unneeded programs and try again".

<snips>
Update. I found a similar situation at the MS KB. That one had
Access running into out of memory errors with 1 gb or more of RAM.
The solution was to update the Jet engine in Access 97.

However, before I could do that I had to update Office SR-1 and SR-2.
When I updated SR-1, during install it mentioned that every Office 97
app *except* Access was getting the upgrade. After that install,
Access opens but when I open a form I get different errors saying:

"MS Access can't load the 's' format." Okay.
"MS Access can't load the 'desc' format." Okay.
and two other similar errors. After that, I can move around the
database, make changes, etc. but I'm worried that doing that with the
errors will corrupt the database. It recommended I make registry
changes (but not which ones) or reinstall Access.

I reinstalled Access twice. I also did a system restore to get rid of
the SR-1 Office 97 update. That didn't work either. I tried
uninstalling MS Office after that, but couldn't. At this point, I'm
no longer using Access 97 on the XP Home computer. I'm starting to
think about formatting and reinstalling XP. Any advice? Thx.

Richard Turner
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Phil Powell | last post by:
Actually the client is saying it sometimes happens and sometimes doesn't happen, and when they refresh their screen it clears itself (I assume the memory clears). Here is line 1135: $result =...
2
by: Simon Stewart | last post by:
Has anyone else experience of imagecreatefromjpeg failing with an error message about memory even though the size of the image being uploaded is nothing like the space available to the script? ...
7
by: Jon Trickey | last post by:
We migrated to 8.1 from 7.2 this weekend. Everything ran ok over the weekend, but we have a light user load then (about 200 users.) Today when we had close to 600 users connecting and running...
1
by: Derrick | last post by:
Thanks to many on this newsgroup, I now have a prototype Windows Forms C# app that reads xml documents into DataSets via XmlDataDocument, and does *stuff* with it. I basically have about 25 megs...
8
by: Kathy Burke | last post by:
Hi. Yet another question. We're running a new asp.net app off a production network server. The PC is a PentiumII/III with 128MB of RAM. When running the app, the memory uses read at about...
6
by: Deadly_M | last post by:
Writing with Visual Basic.net Even the smallest piece of code with no form and no references and the debugging code removed still seems to use around 6000 k what is .net doing to consume that...
1
by: Alexander Cohen | last post by:
Hi, sometimes ill get this error: FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shmget(key=2, size=4153344, 03600). HINT: This error...
14
by: MKoool | last post by:
I have an application with one function called "compute", which given a filename, goes through that file and performs various statistical analyses. It uses arrays extensively and loops alot. it...
12
by: elty123 | last post by:
I have a small C# program (about 400 lines of code) that is only 28kb after compiled. However when it runs (takes a whole 5 seconds) it takes up nearly 20MB of memory and I don't see why. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.