A colleague of mine recently received an upgrade to her PC. It's now got loads of memory, faster HDs and a bloody fast xeon processor in it!

The problem is that Access97 now regularly hangs/crashes when doing routine stuff (usually importing textfiles or running some update queries). Same databases work fine on her old (slower) PC.

Has anyone come across this before? And if so, how did you fix it? (We're trying to avoid Access2000 for now...)

Cheers

How much ram, we have had problems in the office with pc's that have more than 1GB of ram. Reducing memory to 1GB solved the problem.

Isn't there a known problem with using more than 1Gb of RAM in Windows? Access 2000 is a llot more stable than '97. It doesn't have the annoying rounding problems, either.

Phil

It's got 1Gb RAM...

Perish the thought, but have you tried looking on microsofts support site ? Has been known to be helpful, or www.tek-tips.com could be worth a look

Looked on the MS KB site with no joy. Will have a look at tek tips later.....

have you loaded the latest office service pack for office 97~?

What OS are you using?

Why on earth a Xeon processor though :| - P4 I could understand but surely that's overkill for a home PC :lol:

It's got XP on it. Now with SP2 and all the office service packs. So far it seems to be behaving...

Why a Xeon? Because we process hundreds of thousands of records (regarding hospital activity) each month via access, before using excel for building the reports. Both need a hefty PC unless you want to spend the day waiting for queries to run or spreadsheets to calculate

Fair enough - thought it was a home PC but that's pucker business use

In that case bags of memory, fast hdd & CPU are indeed worth the expense

It's got XP on it. Now with SP2 and all the office service packs. So far it seems to be behaving...

Why a Xeon? Because we process hundreds of thousands of records (regarding hospital activity) each month via access' date=' before using excel for building the reports. Both need a hefty PC unless you want to spend the day waiting for queries to run or spreadsheets to calculate [/quote']

fun! Access/Excel always seems to take forever to do anthing complicated.

fun! Access/Excel always seems to take forever to do anthing complicated.

Especially if you're using a 667MHz Celeron with 256Mb of RAM :thumbdwn:

- can imagine that