Document Templates Office 2000, 2003

[Johnson]

I have mail merge templates created in Office 2000 that I use to create
documents. When the documents are opened in Office 2003 a dialog box opens
that asks if I want to run the SQL that created the document.Then when
closing the document a dialog box opens that asks if I want to save changes
to the template that the document was created with. How do I disconnect the
document from the template so this doesn't happen. If you open the documents
in Office 2000 they just open with no SQL warning dialog box and you can
save the documents without any extra dialog boxes opening asking you to
about saving the template. Office 2000 is running on windows 98 pcs and
Office 2003 is running on XP Pro pcs. Thanks in advance.

 

[Robert M. Franz (RMF)]

Hi Johnson

I have mail merge templates created in Office 2000 that I use to create
documents. When the documents are opened in Office 2003 a dialog box opens
that asks if I want to run the SQL that created the document.Then when
closing the document a dialog box opens that asks if I want to save changes
to the template that the document was created with. How do I disconnect the
document from the template so this doesn't happen. If you open the documents
in Office 2000 they just open with no SQL warning dialog box and you can
save the documents without any extra dialog boxes opening asking you to
about saving the template. Office 2000 is running on windows 98 pcs and
Office 2003 is running on XP Pro pcs. Thanks in advance.

There are two independent issues here:

- the SQL warning which is a standard in Word 2003 (security issues
IIRC), and
- the template changing.

You can search through the MSFT KB for something like "Opening this will
run the following SQL" to see whether there's a sensible measure
available/known to suppress this message.

For the template: it's probably easiest if you create Word 2003 versions
of your templates and instruct the users to use the templates
appropriate for your version. Once the templates are "native 2003," this
message should only pop up when the user changes something which might
be played back into the template (like: a style).

I'm not sure if locking the template to read-only would help, but it's
worth a try, too. You can add a short VBA macro that suppresses the
template question by setting the template to saved IIRC.

2cents
Robert

 

[Suzanne S. Barnhill]

See "Opening This Will Run the Following SQL Command" Message When You Open
a Word Document
http://support.microsoft.com/?kbid=825765

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.