Insights and Rants

News and general opinion, often security or computer related, but could be about anything really, including religion, politics, the environment or podcasts. "Never ascribe to malice, that which can be explained by incompetence." -- Napoleon Bonaparte

Tuesday, October 20, 2009

Access97 Security in Forms and Reports

One of my clients just showed me a giant loophole in their Access application, which I wrote. (blush!) When he right-clicks on a report in preview mode, he can export the report to a Word document. Why is this scary? Well, the report happens to be an invoice and in Word you can edit the invoice, something you aren't supposed to be able to do!
How do you disable the right-click facility in a report preview? It's connected to the report.ShortcutMenuBar property. Set this property to a menu macro, and it appears instead of the default one.
In forms it's even easier: set the form.ShortcutMenu property to False, and the right-click doesn't work. This is particularly important for login forms where you don't want the user to be able to change to Design View. Of course in a .mde file that doesn't work anyway, but let's rather be safe than sorry.

Labels: , ,

0 Comments:

Post a Comment

<< Home


-:| [Black and White Inc] | [Defrag Utilities] | [Recommended Freeware] | [Face Painting Fun] | RSS | tweets |:-


All information copyright © 2005-2010 Donn Edwards. All rights reserved. Privacy Policy

Local time:


Visit WebHost4Life Customers
Sorted bru, tagged by Amatomu.com Afrigator
This contact information is private. Do NOT use my email address, phone number or mobile number for any marketing purposes, and do not send me unsolicited marketing messages. CCleaner - Freeware Windows Optimization

Comments on this site are moderated: if they are sensible, on topic and make it through my spam filter they'll usually be accepted.













From 13 Jan 2010:
free counters