Re: multiple users in a secured database

From: Ilan (anonymous_at_discussions.microsoft.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 06:43:01 -0700

any suggestions on how i can make it so admins can go and
edit the data while read onlys can read the data and not
interfere with the people updating the data?

thanks,
Ilan
>-----Original Message-----
>"Ilan" <anonymous@discussions.microsoft.com> wrote in
message
>news:540401c47419$67fc02f0$a401280a@phx.gbl...
>> hello.
>>
>> i have a secured database in access 2003 with the
>> following groups: admin, read-only, full data users.
i
>> have a small office and would like my read-only users
to
>> be able to view the information while full data users
>> update it. is this possible? right now, i tried it
but i
>> get a message saying that a full data user cannot save
>> changes because a read only user is in the database.
any
>> suggestions.
>
>If you are creating read-only users with your security
settings you cannot
>also give them only read-only access to the file and the
folder where the
>file resides.
>
>ALL users need full permission to the file and to the
folder where the file
>resides so that a locking file (LDB) can be properly
managed by Access. If
>a user does not have these rights and they are the first
to open the file
>Access will give them exclusive access to the file since
an LDB cannot be
>created thus locking all other users out.
>
>
>--
>I don't check the Email account attached
>to this message. Send instead to...
>RBrandt at Hunter dot com
>
>
>.
>

Relevant Pages

  • Re: Help - Security Issue
    ... you haven't yet necessarily opened the backend mdb. ... Once you open a bound form, you'll see the ldb show up for the backend. ... I had network people set up the permissions on the folder. ... open the database an ldb file only shows up for the mdw file out on ...
    (microsoft.public.access.security)
  • Re: Loss of A4 page size.
    ... locking file from sometime when your system crashed whilst ... Terry Farrell - MSWord MVP ... When I open this folder there is always an extra ... adjust settings such as fonts etc, ...
    (microsoft.public.word.newusers)
  • Re: Help - Security Issue
    ... I just heard from one of our network guys (a different one than who had set ... Once you open a bound form, you'll see the ldb show up for the backend. ... I had network people set up the permissions on the folder. ...
    (microsoft.public.access.security)
  • Re: Front End/Back End DBs?
    ... > (either as a bound form, or say combo boxes bound to a query) or the ... > The mere act of opening the front end should NOT cause the locking ... locking file to be created, ... the .ldb file was still there. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: All users must be admins?
    ... As far as my experiance is concerned, an LDB is created eveytime an MDB is ... That folder can be placed ... it is not usual to grant admin permissions to users. ...
    (microsoft.public.access.security)