Link to home
Start Free TrialLog in
Avatar of daiwhyte
daiwhyteFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Word Template saved over by user

Hi,

I have a user who has saved over a .dot file and each time it opens following this incident, the data it pulls from our database (via odbc) is incorrect due to the previous data still being in the .dot file.

How can I clear out the old data and reset the form to its previous state (blank) so each time it opens, the new data is pulled from the database.

Thanks
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Open it as a document, edit out the unwanted data, and save it again.

Do make sure that, in future, the template is used correctly. That is to say that it should not normally be opened as a document, but selected via File/New. If necessary, make the folder read-only.
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daiwhyte

ASKER

The file is populated via a odbc connection, in this case - when the template is launched, its populated with name, address details. Whats happened is someone has opened the template and typed over these fields so the data source has gone also.
Do you mean that you have (or had) one or more database fields to display the data?
Yes, Ive now managed to restore a file which has the correct links from backup, from this restore - I have been able to work out how the doc interacts with the db and have corrected the problem. Ive also made the doc's read only to stop future overwrites.
That's good news. But also take note about how to use templates.

If it is on a network share, have all the users set their default location for 'Workgroup templates' to point to the share.
Thanks Graham