Multi user rights

  • Thread starter Thread starter Pim
  • Start date Start date
P

Pim

I have a problem with access. I have a database (backend
and frontend). And I want more people to be able to access
this dbase. Some users will need to add and change
information and others should only be allowed to look at
the data. At this moment I have added different rights to
the folder were this dbase is located. Some have read &
write (R&W) access the other group has read only (R)
access. The problem now is that when someone from the
first group (R&W) is working in the dbase and someone else
from the read only group tries to access the dbase he well
get an errormessage (file is already in use). How can I
solve this problem?

Thanks in advance,

Pim
 
The answer is to implement access security.

Access security is great, but it also is not easy to set up. If you
make a error setting it up no one will ever see the data again.

The answer is to read read read all you can find on it. Be sure to
read:

http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Set up a test database and practice a few times getting things right.
Then you can secure the database in question. After that you can even
secure specific fields if you like.
 
All users require Read, Write, and Delete permissions on the folder where
the mdb is. This is so the ldb file can be created/deleted. If the first
person in doesn't have create permission, they can't create the ldb and it
will open exclusively.

You need to implement Access security as Joseph suggests.
 
Back
Top