Hi guys,
In our small company, we've got an Access Database on our Windows Server 2012, which is shared through the M: unit of the network. Each employee has got its own .mdb file in its own PC with its owns forms. All these forms are "connected to" the Access Database that is located in the M: unit of the server.
I'm trying to deny the insert/delete/update privileges to some employees, so they can only make "select" queries.
I know that I can Allow Deletions property of the form to False (No), but there are about 150 different forms.
I know that I can also remove the Delete Data permission for the table, to prevent users accidentally deleting records. But there are about 100 different tables in the database.
So is it any way to deny inserts/deletes/updates to a user for the whole Access database?
Regards