Sikkerhed på Access projekt (ADP)

http://office.microsoft.com/da-dk/assistance/CH062526751030.aspx

Dit link giver 100% svaret, men jeg er da skuffet over at MS ikke kan tilbyde forskellig sikkerhed op mod tabellerne read/write osv.

Torben

Hi Torben
You can use SQL Server to control what table permissions each user has. Make different database Roles and give Role the relevant permissions. Then add the user to the approperiate Role. Then set  the permissions on each object (table/viewetc) and use the Role instead of the user. Then if a users permissions change you just move it to another role.

This obviously doesnt stop users opening forms in Access but it does stop them altering data if they dont have the correct permissions.

Thanks and good weekend

A user can be a member of different roles.