Hello,

I am trying to set up security on my shared database. What I need is to have
it so that anyone in the organisation can open it as read only. It's very
important that it does not ask for a password but opens automatically as read
only. There are couple of people that would need to be able to update the
information in the database. Is it possible to achieve this? I know that it's
probably not possible to explain the whole process here but I would
appreciete if somene could tell me if this is possible and where to go for
more information.

Many thanks,

Johanna

Johanna Gronlund wrote:

Show quote

Hide quote

You can do this with network security as long as you don't need read only and
read/write users in the file at the same time.  If you do need that then Access
user level security can be used (not for the new 2007 AccDB file format though).

With user level security you normally give zero permissions to the default user
'Admin' and the default group 'Users'.  In your case you would give the Users
group read only permissions instead.  That way your read only users could open
your file with any workgroup and not be prompted for a password.  Your
read/write users however would need to use your secure workgroup file and log
in.  A shortcut could be set up for them that points them at the correct
workgroup when the file is opened.

If logging in is an issue for the read/write users the same shortcut that points
them at the correct workgroup could also pass the username and password as well.

Encrypt Databse Problem
More ULS Problems
Access coding to VB
Security loose ends
Getting round security warnings for task scheduler