<div>
Thanks Joe... glad to hear I'm on the right track :)
</div>


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

<div>
<div class="content wysiwyg-content">
I'm currently working on converting my Access 97 software to Access 2016. &nbsp;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. &nbsp;My thought was to build 3 new tables (Users/passwords, Groups &amp;&nbsp;user/group assignments) and a login page that would access these tables when ever a certain permission was required. &nbsp;Does this sound logical?<br />
<br />
Thanks,<br />
Greg
</div>
</div>


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?

Thanks,
Greg

Access 2016 - User-Level Security

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.