Word 2003 Failes Merging From Access 2002

[Dave]

I have created a merge document in Word 2003, linked to
an Access 2002 database. Everything worked fine until I
moved the database to our server. Even though I changed
the link to the new location, the program hangs every
time I try to merge or view the data.

During the time that the document is hanging Word is
using 50%+ of my CPU resources. There are some I/O Reads
going on, but no writes.

Any one have ANY idea???

I find nothing in the KB about this, so I guess I am
just "lucky".

 

[Peter Jamieson]

FWIW I don't experience this here in simple tests using WinXPPro+Word2003
client and a Win2KSP4 Server. Other than the sort of things I'd try (does
the database behave when you open it from Access? Does changing to an ODBC
connection make any difference?) the one KB article I've come across that
could be relevant is:

Files on Network Shares Open Slowly or Read-Only or You Receive an Error
Message:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814112

(I searched for "word access server hang" if that is any help to you).

 

[Dave]

Thanks for the reply, Peter.

The database is fine. I have tried different ODBC
connections. Even tried exporting everything I need into
Excel (2003) and merging from there.

Other tidbits.
- I tried using the Excel file saved as a shared file,
both open and closed.
- I have 1GB RAM and about 80GB HD space free
- Running WinXP version 5.1.2600 on a Dell Precision 450
with dual XEON 2GHz processors - hyperthreaded.

Could hyperthreading be a problem????

BTW - I KNOW how to spell "fails" - just in a hurry I
guess.

Dave

 

[Peter Jamieson]

I take it the article I referenced didn't lead anywhere useful. No really
obvious ideas here. Have you tried locating your database on a share on the
same PC (i.e. so that Windows will have to get the data via its networking
layers?

I only found one article related to hyperthreading - although this article
is about a problem caused by a specific performance counter that may be
affected n a hyperthreading environment and probably only affects games, I
suppose there could be other similar issues which haven't been
noticed/documented.

http://support.microsoft.com/default.aspx?scid=kb;en-us;327809

There are a few KB articles related to "dual processor" or "multi-processor"
but no obvious matches with the problem you report.

The only other potentially relevant thing I can think of is that on /my/
dual-processor system here, which is an Asus with 2 much slower P3
processors running WinXPPro, I did install a Processor Driver update from
Windows Update (about 18 months ago). Unfortunately for the purpose of
comparing notes I don't actually run Office on that PC but I do remember
that the update seemed to make a substantial performance difference, so I
suppose it may be worth seeing if there are any such updates for your
system.

Is it possible to reconfigure your processors in the BIOS (hopefully without
having to load a host of new drivers and re-activating? E.g. to reduce it to
a single-procesor system?