Security Help

[marklord]

I want to add some security to my database, with three users:-

(1) Full access with read/write/update/delete access with the ability to modify designs, queries, relationships etc. etc.
(2) Normal Access - able to use forms to read/write/edit/append/update data in tables as well as run queries and macros via buttons on forms.
(3) Read-only - access to all forms, can run queries etc. but can not actually change any data themselves by editing data stored within text/combo boxes.

I understand this is possible via Tools>Security, but I have not been able to successfully do this, often just locking myself out from the database completly.

Does anyone know of any simple guides which will help me accomplish this?

Cheers,

Mark

 

[The_Doc_Man]

You need to search this forum for keyword WORKGROUP or WORKGROUPS

You will find many answers that might help. Speaking of which, read the Help Files on WorkGroup security while you are at it.

That is your starting point.

 

[marklord]

thanks, i'll take a look - nothing else i searched for seemed to return me anything useful.

mark

 

[Oldsoftboss]

Here's one document I downloaded some time ago. Hope it helps.

Dave