How to Protect SQL view?

Question

Hello,

I have a query built in SQL view. I have people look in my SQL view and mess with my SQL code.

Is there a way to protect the SQL view (like password) so that you need the right password to look/ modify the SQL view? Thanks

Answer 1

Distribute your db Front-end as an MDE and use and AutoExec macro to run some code to hide the Object Browser.  Then your user will only have access to what you want them to have access to (ie: forms and reports).

---

Daniel Pineault, 2010 Microsoft MVP

http://www.cardaconsultants.com

MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Distribute your db Front-end as an MDE and use and AutoExec macro to run some code to hide the Object Browser.  Then your user will only have access to what you want them to have access to (ie: forms and reports).

 

Still have to disable the F11 key as well, or else they can get to the database window and open and modify the queries.

---

Bob Larson, Former Access MVP (2008-2010)

Answer 3

No, not really.  But the best way is to not let users get to the database window to begin with.  Lock them out using several features including removing the Shift Bypass Key and disabling the F11 key by unchecking the USE ACCESS SPECIAL KEYS in the startup options.

Oh, and you should work with forms and not in queries.  With forms you can protect things much better.  But if they have a query open, they can go into the design view fairly easily.

---

Bob Larson, Former Access MVP (2008-2010)