Unprotect a Word Template

  • Thread starter Thread starter JMCS
  • Start date Start date
J

JMCS

I posted something similar a few days ago, but it remains unresolved and has
run out of steam. I will be more specific this time in the hope that someone
can give me a quick and precise answer.
How do I unprotect a Word Template (I know the password) from within Access
(2003) so I can complete fields, and then re-protect the document so users
cannot change anything? This does not need high security - it is simply a
means of preventing changes after the data has left the database. The
internal users will not dig deeply to bypass the password protection, and a
copy of the printed document will be securely stored.
Thanking you in anticipation

JMCS
 
What have you come up with so far? You could work with the protected property
and set that to your needs:

if you know the password you have to somehow pass that in the unprotect
option. assuming you don't want to hardcode that you might have to store that
in a constant and create a mde file from your db.

from word you can use unprotect.me and than provide the password.
 
Thank you for taking the time to reply, but that is not the answer I am
looking for. All the programming must be done within Access, so I am looking
for Access code which will unprotect (using a known password) an open Word
document, allowing fields to be completed by Access, then protecting it again
using the same password.
JMCS
 
Luckily, I have cracked this one myself, so if anyone is interested, the tack
I had originally tried was nearly there. The key was adding the Word library
as a Reference (I'd worked that out) then (where I was going wrong - I didn't
get the code right first time) use Word code within the Access environment.
JMCS
 
Back
Top