Hi Folks,
I'm planning to implement a "light" security in Access 2010 for a database I'm building, using VBA in the method outlined here:
http://www.accesssecurityblog.com/po...ccess-VBA.aspx
But it also seems like you could do it by splitting the backend and frontend and distributing different frontends to different people depending on what kind of access they have.
Has anyone done security that way (with different frontends)? How secure is it? Are there any advantages / disadvantages to doing it that way over using VBA to enable and disable access to forms?
Thanks for any tips!