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

richard turner

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

Subscribe Reply

10840

richard turner

On Thu, 11 Dec 2003 11:31:19 -0500, richard turner <rt*****@ecg.co m>
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

Similar topics

4692

Fatal Error: Allowed memory size of 8388608 bytes exhausted - HELP

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 = mysql_query($this->query, $this->dbcnx) or die(@include("$DOCUMENT_ROOT${devpath}errors/query_error.php")); It is found here in this class method:

PHP

11048

imagecreatefromjpeg failing with lack of memory

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? Is imagecreatefromjpeg particularly memory hungry? Immediately prior to the failure memory is given as 2405072 The jpeg being uploaded is 812201 in size Smaller jpegs work fine. jpegs created by different means all seem to fail if the size is...

PHP

4972

Severe memory problem with V8

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 applications, the db2syscs.exe process started gobbling up memory until it hit about 1.7 gigs (which seems to be the limit from what I've read) then it started crapping out.. We have shrunk the buffer pools to much lower that they used to be in 7,...

DB2 Database

2027

XmlDataDocument/DataSet memory usage

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 worth of xml data that I read in and operate on. Once loaded, before doing anything of substance with the data, my app's memory footprint goes up to nearly 140 megs right off the bat. Question is, if this is not an expected observation, what...

C# / C Sharp

1466

How much memory SHOULD user pc need running asp.net app?

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 190MB. Just looking for some opinions. The app is not that complicated. Runs on our internet. Some SQL db used and HTML docs are rendered using XmlTransform class.

ASP.NET

1128

excessive memory usage ?

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 amount of memory ? how can i stop this from happening ? I'm trying to create a small compact efficient piece of code that will be constantly backgound running and people just wont take it seriously if its using that amount of precious memory on...

Visual Basic .NET

3173

Shared memory segment error

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 usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currently 4153344 bytes), reduce PostgreSQL's shared_buffers parameter (currently 400) and/or its...

PostgreSQL Database

2737

Tracking down memory leaks?

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 prints the results of it's statistical significance tests to standard out. Since the compute function returns and I think no variables of global scope are being used, I would think that when it does, all memory returns back to the operating...

Python

12156

Small C# program takes up too much memory

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. Some of the assembly I used: using System; using System.Collections.Generic;

C# / C Sharp

9541

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10251

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10225

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10027

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9072

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7564

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5463

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4139

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General