I have an Access button that basically does the following:
On Button Click open "Account Profile Form.doc"
Edit "Account Profile Form.doc"
SaveAs("NewUniqueFileName")
The first run works fine. However, if I don't close the document then on the second run I get "Account Profile Form locked for editing by ME." Yet, it doesn't seem to be open because it doesn't appear in msWord and afterall, I previously saved it under a new file name. What am I missing here? Thanks!
On Button Click open "Account Profile Form.doc"
Edit "Account Profile Form.doc"
SaveAs("NewUniqueFileName")
The first run works fine. However, if I don't close the document then on the second run I get "Account Profile Form locked for editing by ME." Yet, it doesn't seem to be open because it doesn't appear in msWord and afterall, I previously saved it under a new file name. What am I missing here? Thanks!