Securing data views

[RobertIngles]

Is it possible to pw protect a db so that the user only sees data related to them?

[mike60smart]

Hi Robert
Usually this is covered by having a Login Form and giving each user various permissions i.e Edit, View, Add, Delete data

[RobertIngles]

Thanks Mike!

[ArviLaanemets]

Another way will be having separate FE's for different user groups - e.g. for working with bookkeeping, or items arrivals, sending, and storaging, or production planning and registering, etc. Every group will have access only to their needed data.

[NoellaG]

Another option is to move the back-end tables to SQL Server (express), create data views and use the build-in security there to set the correct permissions. Less work and more secure.

[Gicu]

Depending on your needs... If you want to lock\hide various controls on forms based on what kind of access is granted to the current user you could implement something like I have in this free utility. The access rules are stored in a hidden custom system table and not hardcoded in VBA making it easier for a DBA to edit them.
https://forestbyte.com/ms-access-uti...access-levels/
Cheers,