Hi,

I've created a template, that when a user clicks a buton, the document
merges with a record in a SQL db.

Works great except that when a user opens up the document later, they
in turn open the project of the template (or a reference to the
template project)

Ultimately this locks me out of making changes to the actual template
file, because the user creates a lock on both files when they open just
the doc file

Am I saving the code for the merge in the wrong place? or is there a
way to break the connection to the template code after the sub routine
is called?

thanks,
Paul