Multi-User Security

[igglebop]

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!

[June7]

Security issues are the same.

A big disadvantage is maintenance. If the various DBs use the same objects, just with different filtering and sorting, then any edits could mean modifying multiple FEs. What a pain. I can't imagine anyone willingly implementing this method.