Originally Posted by
NTC
There are good reasons the old security design was discontinued. Today a developer must implement whatever security is appropriate to the user base. In general removing the F11 capability (to the Navigation Pane), distributing an .accde file time (cannot go into design view) and password protecting the file itself are the 3 core security elements to be implemented if thought necessary. It should be understood that this is secure for the level of the average un-motivated, opportunistic or non technical users. If there is a motivated, technically adept serious hacking concern - another technology should be used for your application.
Anything inside the user interface, such as limiting users to viewing/editing specific records, requires developing a log-in screen to obtain user identification and then designing object behavior and record set queries with that information.