Is this the same database that we discussed a while back? Word XP
(2002)? Are you both also using the same version of Windows and both
using Access XP?
There is a list of fixes in /Word/ SP3 at
http://support.microsoft.com/kb/836036/
Although this list may not be complete, none of the items listed seemed
obviously related to this problem. Same for the Access SP3 list.
"Opening this document will run the following SQL command: SELECT * FROM
[queryname]. Data from your database will be placed in the document.
Do you
want to continue?"
On his machine, no such message comes up.
The most likely explanation for this is that his machine has the
registry patch described at
http://support.microsoft.com/kb/825765
and yours does not.
Also, when first connecting the database to the letter, on my
machine, I get
a box to choose from which type of database it is - I choose MDE (second
choice), on his machine, even starting from scratch, there is not
prompt to
choose.
DO you mean in the "Select data source" dialog box? And do you mean the
"Files of type" selection drop-down. Here (Word XP SP3) I see the a list
which starts with
All files (*.*)
All data sources (various extensions including .mde)
Office Data Connections (*.odc)
Access Databases (*.mdb, *.mde)
However, I get the impression you are seeing a different dialog
altogether - can you provide a bit more detail?
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
On 08/10/2009 19:52, 4charity wrote:
I have an access database that I am launching a MailMerge from. The data is
on the server, while the frontend of Access is on my hard drive, as well as
the MailMerge templates. It takes a long time to run, but eventually does. I
have now put the identical front end on one of our processor's machines. It
really struggles to run the MailMerge, and many times crashes the Access
application. I am trying to figure out why it would work on my machine, and
not his. We are both running Word 200, although I have SP3, he has SP2. One
major difference I have seen is that on starting the Word App, I get the
message from Word:
"Opening this document will run the following SQL command: SELECT * FROM
[queryname]. Data from your database will be placed in the document. Do you
want to continue?"
On his machine, no such message comes up.
Also, when first connecting the database to the letter, on my machine, I get
a box to choose from which type of database it is - I choose MDE (second
choice), on his machine, even starting from scratch, there is not prompt to
choose.
Could any of this be related to the unstable conditions we are seeing on his
machine? The other processors have the same version of Word as he does, and
it does not reliably run on his machine, so I cannot release it.
Thanks.