Access 2016 - User-Level Security

Greg_L_WER used Ask the Experts™
I'm currently working on converting my Access 97 software to Access 2016.  So far the conversion appears to have worked well though I'm currently trying to figure out my best route to replace my users/user group access permissions into something that Access 2016 will use.  My thought was to build 3 new tables (Users/passwords, Groups & user/group assignments) and a login page that would access these tables when ever a certain permission was required.  Does this sound logical?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Architect / Application Developer
Top Expert 2007
Sounds like you will be having loads of fun :-)
And yes ... that approach seems pretty much what you need as a start to emulate (aka Roll Your Own) the ULS you are use to.



Thanks Joe... glad to hear I'm on the right track :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial