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 --