Protecting a Report from being modified

[Brenda]

First of all thank you for taking the time to look at this post. Your
knowledge on this subject is greatly appreciated.

I have several reports that I would like to possibly password protect for
structure similar to what Excel can do. I do not want to password protect
the report to prevent it from being accessed. I only want to protect it from
being modified. Is this possible?

Thank you!

Brenda

 

[Daniel Pineault]

Have you looked at implementing security where you can establish which users
can modify the design of Access objects?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[John W. Vinson]

First of all thank you for taking the time to look at this post. Your
knowledge on this subject is greatly appreciated.

I have several reports that I would like to possibly password protect for
structure similar to what Excel can do. I do not want to password protect
the report to prevent it from being accessed. I only want to protect it from
being modified. Is this possible?

Thank you!

Brenda

Design the report in a .MDB file (or .ACCDB, if you're using A2007); save the
file as a .MDE or .ACCDE file. Keep the original for future maintenance!! If
you give the users the ...E file, they won't be able to make any design
changes to it.

 

[Brenda]

Thanks everyone for the great ideas. With your help the problem is solved.
The MDE method seemed to work the best and is exactly what I needed. Did not
know that even existed! Thanks again!

 

[Brenda]

Thanks Daniel. Will give that a try. Brenda

Have you looked at implementing security where you can establish which users
can modify the design of Access objects?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Brenda]

Thank you John. The MDE method is exactly what I was looking for. I learned
something new today! Brenda