Richard, I have just finished working through your outstanding Security Database. In a rating of 5 starts, it gets 10!  I do have two questions on the later lessons.
In Lesson 32 re ACCDE file. I am working with Access 2010 which may be why I have had this experience. I had repeated difficulty in making the ACCDE file. Finally, after searching the web for clues, I compiled the database first, then tried to make the ACCDE file and it worked then.  Have any other of your users found it necessary to compile before creating the ACCDE file in Access 2010?
Question 2. In Lesson 36, at 9:35 you logon and make a comment that says  notice for me I ve got all my full menus because of the db properties in the admin button we created.   I see that in the video. But when I logon as Richard 123 my menus are limited and if I show the DBW I still can t work with the forms (or even queries) even if I unlock the database without exiting. I can create links but I still have limited menu and no working ability with queries and forms.
What will work: at this point I unlock the database, exit and return. Whoever next returns   no matter what their permission level   sees the navigation pane and can access objects and use full menus. When I as an admin open the db, I can work with it and then lock it again. Then the ACCDE file will work fine for others without giving them access to full menus and nav pane.
Does this behavior surprise you?  Anyone else have this problem?  Thanks so much for such superb teaching!  Bonnie

---

Reply from Alex Hedley:

It's been while since I've done it but I thought compiling the db was covered, maybe this is in another one. You're right though, you need to before it'll work.

Are you unlocking the db then creating the accde as that would leave it unlocked for everyone.