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