On 31/05/2010 16:48, Stefan Hoffmann wrote:
hi Bob,

On 31.05.2010 17:26, Bob H wrote:
I now want to restrict write access to some users and only allow 2 users
to do that, while all can have read access.

How can I achieve this situation and what is the best or easiest way of
doing so.
There is not really an easy way.

There are two steps:

1) Implement a security model.

2) Change your forms in such a manner that these restrictions are
properly used - the forms AllowDelete, AllowEdit and AllowInsert
properties must be set accordingly to the permissions.

In your case I would recommend using SQL Server 2008 Express as database
backend (it's free). Because you can use integrated Windows security and
manage the permissions in the AD.
Under normal circumstances your application (front-end) should work
without flaws, but there are some pitfalls. See JStreets whitepaper 'The
Best of Both Worlds: Access-SQL Server Optimization' at

http://www.jstreettech.com/cartgenie...rDownloads.asp


The other option is to use the Access integrated security model:

http://office.microsoft.com/en-us/ac...662271033.aspx

There is also a "third" option: Implement a kind of user login and role
membership yourself.


mfG
-- stefan --

Hi Stefan,
thanks for the information and links.
From what I have been reading, I agree, there does not seem to be an
easy way at all. In fact I would go so far as to say even complicated in
some of what I have read, for a relative newbie like me.
Security and passwords in Access is a whole new ball game, like
something else to learn before implementing any of it.

All I want to do is stop some users from editing the data on the forms,
so maybe I should go for the third option. So how can I do that. I have
been playing around with security and passwords on my own PC, but that
is different from the situation at work.
For example, if I set a password for myself that only requires me to
login, so how can I set a password for another user with write access,
and then one for users with read only access.

Thanks