restrict edit of database

[mev2018]

hiya,

I have two tables in one database.

I have a frontpage menu which gives two buttons.

1. to access form1 (linked to table1)

2. to access form2 (linked to table 2).

If I restrict access to the whole database to read only, it means users cannot edit table no.2, which I need them to.


So is there a way that I restrict users to do the following:

Read-only form no.1 (linked to table1) - no editing allowed.

and

Being able to add/edit form no.2 (linked to table2) - editing allowed.

wayne

 

[Kamolga]

Hi,

In the form below, the user can see EmployeeID, Name, etc but can not edit them (he can edit Contacts which are another table though):

[/URL][/IMG]

My way to get is in design mode, get the property sheet and in data tabk, get enable to no and locked to yes.

[/URL][/IMG]

 

[mev2018]

Thank you for that, but the enabled option will disable the form for everyone, I need it for only a select few, so say I have 8 users, 4 of them need to read-only and 4 of them will be able to edit.

The enabled option will blanket all users, unable to allow anyone to edit/add records.

wayne

 

[alansidman]

This is a lengthy read through, but I believe it may serve to solve your issue.

https://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html

 

[Kamolga]

I have 8 users, 4 of them need to read-only and 4 of them will be able to edit

Ah sorry did not understood it that way. To my limited knowledge, there are 2 ways to do it:

1. alansidman method, a table with permissions and macros enabling/desabling forms or editing based on ligin/password
2.splitting the database in frontends (database tools tab, Access Database) with one which locked in editing and not the other one.

1 is more work at the beginning, 2 is more work afterwards