Restrict access to Table but allow users to Forms

[grafilo]

On other versions of Access it was easy to deny other users access to tables while still allowing them to complete forms and run macros. How do you achieve this with the 2007 version? - Gina Grafilo

[boblarson]

Pretty much the same way as you did in the other.

You disable the Bypass Key and uncheck the Use Access Special Keys checkbox in the Startup Options, and create an ACCDE file (new MDE version). You can then rename it to ACCDR and it will run as if under the Runtime (you'll need to provide custom ribbons and good error handling for that).