Read only access on shared drive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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.
 
Back
Top