Hi Richard,

Thank you for your split database seminar; it was very helpful.  I plan on taking your security seminar as what I really want to know how to do is to lock down the navigation bar together - even keeping users from holding 'shift' and bypassing the startup.

I am using Access 2007 and created the ACCDE file version hoping that it would hide the design of all of the objects.  While this was successful in hiding form designs, I noticed that the queries were still accessible to the users.  I wanted to know what your thoughts are on designing the queries using either SQL or the QBE grid and then feeding the control source with the SQL code.  This will keep the query from being created and will keep the user from accessing both the form and query design.  Of course, this is a temporary solution that I would use until I take your security seminar.

Thank you for all of your excellent videos!

---

Reply from Richard Rost:

For advanced users (and databases that I create for myself and for clients) I use as FEW queries as possible. I prefer writing SQL in my forms and reports unless the query is complex.

An ACCDE will not hide the table data or structure, or query structure. It just locks down your forms, reports, macros, and modules.