I am creating an Access 2010 database and want to clarify when it comes to concurrency and security. I would like for the application to display only the menu form with several buttons, including the login button. Most buttons will be disabled until the user logs in at what point based on their permission group; Viewer (Deafault), worker, editor, administrator.
In addition, the administrator should be the only one who can see the access database, and the rest is limited only to viewing forms.
I just tested the default implementation of concurrency, but kept my database on a shared network and tried to contact it and the employee. It turned out that if one of them turned to the database, he blocked it from the others, and if we both tried at the same time, it would become read-only.
So, I'm just looking for tips on how to get started.
source
share