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.

thank you.
Ilan

"Ilan" <(E-Mail Removed)> wrote in message
news:540401c47419$67fc02f0$(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in
message
>news:540401c47419$67fc02f0$(E-Mail Removed)...
>> 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
>
>
>.
>

You have already implemented security; the issue now is related to windows
security.

*All* users of the mdb require full windows permissions on the folder where
the mdb is.

Ilan wrote:
> 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" <(E-Mail Removed)> wrote in message
>> news:540401c47419$67fc02f0$(E-Mail Removed)...
>>> 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
>>
>>
>> .

--
Joan Wild
Microsoft Access MVP