Microsoft Access is a very successful tool for producing multi-user collaborative applications However, with Microsoft's reduction of support for MS Access, user login, and security features have been reduced to almost non-existent.
however, some user-based security solutions are produced by userswith VBAa coding.
In the login system, which is the subject of this article, we define an authorization level I named 'Rank', for each user. We can use this unique string in addition to the active user name in queries.
Accordingly, a string is created for each user using the code of their superior. In each record created this way, that user's authorization level is marked. Thus, the Supervisor can monitor and edit the records of the staff team.
You can find the detailed information on our youtube video and download and review the file.
コメント