Protecting Report when emailing

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

I created a report that needs to be sent to microsoft word and then emailed
on. My problem is that I cannot make the report such that it cannot be
changed by the receiver.

Can I, and if so, how do I protect the document? Once the document is
received the end user is to insert information in certain fields (all
unbound) and email back to me. I know that I can lock the report here, but
what do I do when it goes to word and then emailed? If it is protected
document, the information cannot be input without "messing up" the report.

Thank you, Joy Rose
 
Joy:

Word is not designed to a be form package. The "security" issues you've
identified have no real work around; Word is not a forms package. Adobe
PDF forms might be work well, however, your user would need to have full
Acrobat to be able to save the form (won't work with reader).

Excel on the other hand does allow you to protect a Worksheet within a
workbook and at the same time "un protect" specific cells within that sheet
which allows the user to enter data but not change the layout. You can
create pseudo form in Excel and link specific cells where the user will
input data to another worksheet in the workbook where the data is layed out
in columns and rows so that its easily importable back into Access. You'd
do this by setting the cell reference in the row and column worksheet to be
something like = !DataEntrySheet!A5.

Hope this helps.
 
Back
Top