I'm using Access code to populate a Word report.
I have a recordset to get the values from db tables, and replace or insert at bookmarks of Word. Then save the doc and close the recordset.
Everytime there is a msg of MS Word came out: This file is in use by another application or user. (C:\Documents and Settings\...\Normal.dot).
If I click on "OK" and try to close it, another msg: Changes have been made that affect the global template, Normal. Do you want to save those changes?
What do they mean? Why I got these msg?
'These are the codes I'm using
Public appWord As Word.Application
Public doc2 As Word.Document
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Set appWord = New Word.Application
appWord.Visible = True