problem file lock on merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fry - 31 Jan 2004 12:03 GMT

Bonjour ,

Je pilote word 97 au travers d'une application VB6.

Je lance une cession word

J'ouvre un document (word.doc) word et je r?alise une fusion avec (word.txt)

J'enregistre mon document fusionn?.
Je ferme mon document

Si je fais ce traitement plusieurs fois j'obtiens un message d'erreur a la
lecture de mon fichier de donn?es (erreur 70 permission refus?e).

c'est en fait word qui s'est appropri? mon fichier car si je ferme la
fenetre word je n'ai plus de probl?mes pour acceder a mon fichier.

Pourtant la fenetre word est bien vide !

Merci de votre aide.
Ah oui ce probl?me se pr?sente sous office 97 office XP sous windows XP et
sur server 2000.

Tous les produits ont les derniers update.

Reply to this Message

Cindy M -WordMVP- - 02 Feb 2004 16:09 GMT

Hi Fry,

I'm going to answer here because, if I follow correctly, this problem
description contains an important bit of information missing in the English
version :-)

You perform the process numerous times, and at some point, Word is saying 2hte
file is locked". Yes?

This is, and has always been, generally an issue with Word: you can never be
quite certain when it will release a file that it has once accessed. I'd say
the quickest and easiest thing to do in the long run would be to trap this
error when it occurs. You can either loop until Word finally releases it,
close and re-open Word, or create a new text file with an incremented name and
attach that as the data source. (And at some point, your application can check
for and delete "old" word.txt files.)

You may find other ideas in one of the word.vba newsgroups. Be sure to
emphasize that the problem is with Word locking a file, and not with mail
merge, per se.

> Je pilote word 97 au travers d'une application VB6.
>
[quoted text clipped - 12 lines]
>
> Pourtant la fenetre word est bien vide !

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

fry - 03 Feb 2004 10:59 GMT

hi cindymeister,

thank's for answer.
You have understand my question.
it's the file use in my vb application when i do my document.mailmerge that
stay lock.

Closing word is a good idea.But it become very slow whn i make 8000
documents.

For information,

I have find a solution for office 97 searching in the kb Microsoft , i put
the patch sr2 and i have no longer problem with office97.

the problem stay on office XP and i have all the patch sp1 and sp2.

we can see this problem at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;151020

and

http://support.microsoft.com/default.aspx?scid=kb;EN-US;163367

But i search a solution for office XP .

thank's for help

"Cindy M -WordMVP-" <C.Meister-C@hispeed.ch> a ?crit dans le message de
news:VA.0000937a.00a9fe3f@speedy...

> Hi Fry,
>
[quoted text clipped - 22 lines]
> >
> > J'ouvre un document (word.doc) word et je r?alise une fusion avec

(word.txt)

> > J'enregistre mon document fusionn?.
> > Je ferme mon document
[quoted text clipped - 14 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 04 Feb 2004 10:53 GMT

Hi Fry,

> Closing word is a good idea.But it become very slow whn i make 8000
> documents.

Understandable :-) OTOH, if you could test that file, to find out
whether it's been locked, you would only have to close and restart
Word for those (hopefully few) occasions?

As I said, otherwise you should try checking in the word.vba groups
whether someone there has any good ideas about how to get around the
problem (it's not only a problem with mail merge!)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message