USers and permissions

[Shazz]

Can anyone help me, I want to be able to set permission so That only myself and one other person can access add data to my database, everyone else can have read only access, can anyone tell me how I go about this?

Thanks in adavance of your kindness.

Shazz

 

[vorn666]

Hi,

Can you disable on all forms the ability to add new records, then add a button which prompts for a password which (if correct) alters the add record ability to the form? or edit the locked properties of the required fields if it is an existing record?
It's a crude solution but should work fine.

 

[Dennisk]

far better to implement security properly using a workgroup , after all that is what it is there for. Search this site for security, workgroup, logon, login, to find all the posts and links regarding this subject

 

[statsman]

Dennisk is correct. The way to approach this problem is to create workgroups. You assign the permissions to the group, then assign the users to the group based on their required permissions. This avoids the problem of having to assign specific permissions to each user.

For an execellent overview of Access security go to:

http://www.geocities.com/jacksonmacd/