Problem with MSWord 2003 and automation in MSAccess.

[jimtmelb1]

Hi,

I have an Access 2000 database. Using automation a user can send open a document in MSWord from the database and it also performs search and replace with values from the database and the document is open in MSWord. It also saves the document to a default location.

Well this works fine on all version of MSWord 97 and above.

Until recently some of my users that have MSWord 2003 are having a slight problem. It creates the document, saves it, the search and replace occurs but the document doesn't open in MSWord. The user has to use File Open and find the document. It's not all MSWord 2003 users just some. Some were working okay with Word 2003 and suddenly this problem started.

Is there any known issues I should be aware of. Can somebody give me some info to why this could be happening.

I will have to get Word 2003 myself and try replicate the problem.


Set docWord = appWord.Documents.Open("test.doc")
This is the line that opens the doc, but even with MSWord open it doesn't show me the document.

Thanks
Jim

 

[jdgreen]

Have your Word 2003 users check their security settings for Macros. There is a lot more security built into Office 2003 that can cause headaches for files created in a previous version. I can't say this will definitely do the trick, but it is one thing I've dealt with since our upgrade.

John Green