Access to Word Automation only works once

[kw2oak]

I am firing-up 'word' from Access 2000 using 'automation' with the Get Object instruction.
I then add a new document and work with the 'active document' placing field values that I have stored in variable before calling word - this works fine first time and then will not work again until 5 or 6 minutes later!

It makes no difference whether I shut down the database - I ahve checked the Task Manager to see if a word session is still open and it is not -- I use the 'set object = nothing' command in my code to do that.

Any suggestions?

 

[PHV]

Are ALL of your word objects FULLY qualified in your code ?
I.E. myWordApp.ActiveDocument.SomeThing instead of ActiveDocument.SomeThing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244