When I open a Word document with links (for instance a mailmerge) I get a dialog "Yes" or "No" to allow SQL access. I select "Yes" and away I go.

When I open the same document from VBA it opens without showing the dialog, having assumed that the answer is "No". Then I can't do anything with the document.

Is there a way from VBA to open the document to the dialog so that I can answer the question as "Yes" ?

Or is there another workaround to open the document with SQL access ?

Many thanks