Hi im looking to set the access rights to a database, i want 1 user to have
full access rights ( a username and password) and the rest of them to have
only read only access,

Is this possible.

Thanks

"Help Me Please" <(E-Mail Removed)> wrote in message
news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> Hi im looking to set the access rights to a database, i want 1 user to
> have
> full access rights ( a username and password) and the rest of them to have
> only read only access,
>
> Is this possible.
>
Yes but it is not straightforward. First you need to read and understand
the Access security FAQ. There's a link to it on my web site but be
prepared for a steep learning curve and have patience. Most of all, be sure
to work on COPIES of your files in case you lock yourself out. Also, don't
be tempted to skip bits of the FAQ, it's ALL relevant.

Regards,
Keith.
www.keithwilby.com

I have read various help guides that i have been told to read, but dont
understand how i would create the different users, i have tried different
ways but have been unsuccessful. Im just looking for some guidence in how to
do it.

"Keith" wrote:

> "Help Me Please" <(E-Mail Removed)> wrote in message
> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> > Hi im looking to set the access rights to a database, i want 1 user to
> > have
> > full access rights ( a username and password) and the rest of them to have
> > only read only access,
> >
> > Is this possible.
> >
> Yes but it is not straightforward. First you need to read and understand
> the Access security FAQ. There's a link to it on my web site but be
> prepared for a steep learning curve and have patience. Most of all, be sure
> to work on COPIES of your files in case you lock yourself out. Also, don't
> be tempted to skip bits of the FAQ, it's ALL relevant.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>

"Help Me Please" <(E-Mail Removed)> wrote in message
news:11BD3CD9-29C6-491B-9FB4-(E-Mail Removed)...
>I have read various help guides that i have been told to read, but dont
> understand how i would create the different users, i have tried different
> ways but have been unsuccessful. Im just looking for some guidence in how
> to
> do it.
>
I understand your frustration and there's a step by step example on my
website which might help clarify things but there really is no substitute
for the FAQ. Good luck.

Keith.

I got told to use the wizard in access to set the rights, i have the password
one working but i cant seem to find the read only part.

"Keith" wrote:

> "Help Me Please" <(E-Mail Removed)> wrote in message
> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> > Hi im looking to set the access rights to a database, i want 1 user to
> > have
> > full access rights ( a username and password) and the rest of them to have
> > only read only access,
> >
> > Is this possible.
> >
> Yes but it is not straightforward. First you need to read and understand
> the Access security FAQ. There's a link to it on my web site but be
> prepared for a steep learning curve and have patience. Most of all, be sure
> to work on COPIES of your files in case you lock yourself out. Also, don't
> be tempted to skip bits of the FAQ, it's ALL relevant.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>

Hello.... I have a question that is related to this topic. I thought that I
had security figured out on my database. The file is on a network server. I
set myself up as a user with full permissions, and two others as "read-only."
When I open the database (as a full permissions user), the other two users
(read-only) are unable to open it. They get an error message: "Could not
use 'Admin'; file already in use." Is this something that I can fix, or is
that just the way it is?
Thanks.
--
Julie


"Keith" wrote:

> "Help Me Please" <(E-Mail Removed)> wrote in message
> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> > Hi im looking to set the access rights to a database, i want 1 user to
> > have
> > full access rights ( a username and password) and the rest of them to have
> > only read only access,
> >
> > Is this possible.
> >
> Yes but it is not straightforward. First you need to read and understand
> the Access security FAQ. There's a link to it on my web site but be
> prepared for a steep learning curve and have patience. Most of all, be sure
> to work on COPIES of your files in case you lock yourself out. Also, don't
> be tempted to skip bits of the FAQ, it's ALL relevant.
>
> Regards,
> Keith.
> www.keithwilby.com
>
>
>

Julie,
Do you mean "full permissions" and "read-only" on the folder where the
database is stored?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"Julie" <(E-Mail Removed)> wrote in message
news:16B1419F-6271-4796-B420-(E-Mail Removed)...
> Hello.... I have a question that is related to this topic. I thought that
> I
> had security figured out on my database. The file is on a network server.
> I
> set myself up as a user with full permissions, and two others as
> "read-only."
> When I open the database (as a full permissions user), the other two users
> (read-only) are unable to open it. They get an error message: "Could not
> use 'Admin'; file already in use." Is this something that I can fix, or
> is
> that just the way it is?
> Thanks.
> --
> Julie
>
>
> "Keith" wrote:
>
>> "Help Me Please" <(E-Mail Removed)> wrote in
>> message
>> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
>> > Hi im looking to set the access rights to a database, i want 1 user to
>> > have
>> > full access rights ( a username and password) and the rest of them to
>> > have
>> > only read only access,
>> >
>> > Is this possible.
>> >
>> Yes but it is not straightforward. First you need to read and understand
>> the Access security FAQ. There's a link to it on my web site but be
>> prepared for a steep learning curve and have patience. Most of all, be
>> sure
>> to work on COPIES of your files in case you lock yourself out. Also,
>> don't
>> be tempted to skip bits of the FAQ, it's ALL relevant.
>>
>> Regards,
>> Keith.
>> www.keithwilby.com
>>
>>
>>

Lynn:

No... on the folder where the file is stored, the we all have full access.
I set up the "full permission" & "read-only" access from the user-security
wizard in Access.... The "read-only" users can open the file when I'm not
using it, but they can't open it when I have it open (full permission).
Thanks for your help.
--
Julie


"Lynn Trapp" wrote:

> Julie,
> Do you mean "full permissions" and "read-only" on the folder where the
> database is stored?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conrad...essjunkie.html
>
>
>
> "Julie" <(E-Mail Removed)> wrote in message
> news:16B1419F-6271-4796-B420-(E-Mail Removed)...
> > Hello.... I have a question that is related to this topic. I thought that
> > I
> > had security figured out on my database. The file is on a network server.
> > I
> > set myself up as a user with full permissions, and two others as
> > "read-only."
> > When I open the database (as a full permissions user), the other two users
> > (read-only) are unable to open it. They get an error message: "Could not
> > use 'Admin'; file already in use." Is this something that I can fix, or
> > is
> > that just the way it is?
> > Thanks.
> > --
> > Julie
> >
> >
> > "Keith" wrote:
> >
> >> "Help Me Please" <(E-Mail Removed)> wrote in
> >> message
> >> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> >> > Hi im looking to set the access rights to a database, i want 1 user to
> >> > have
> >> > full access rights ( a username and password) and the rest of them to
> >> > have
> >> > only read only access,
> >> >
> >> > Is this possible.
> >> >
> >> Yes but it is not straightforward. First you need to read and understand
> >> the Access security FAQ. There's a link to it on my web site but be
> >> prepared for a steep learning curve and have patience. Most of all, be
> >> sure
> >> to work on COPIES of your files in case you lock yourself out. Also,
> >> don't
> >> be tempted to skip bits of the FAQ, it's ALL relevant.
> >>
> >> Regards,
> >> Keith.
> >> www.keithwilby.com
> >>
> >>
> >>
>
>
>

Julie,
That's definitely a little odd then. Are you certain that you are not
opening the database in exclusive mode?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html



"Julie" <(E-Mail Removed)> wrote in message
news:2FF1E199-5385-4617-B2AC-(E-Mail Removed)...
> Lynn:
>
> No... on the folder where the file is stored, the we all have full access.
> I set up the "full permission" & "read-only" access from the user-security
> wizard in Access.... The "read-only" users can open the file when I'm not
> using it, but they can't open it when I have it open (full permission).
> Thanks for your help.
> --
> Julie
>
>
> "Lynn Trapp" wrote:
>
>> Julie,
>> Do you mean "full permissions" and "read-only" on the folder where the
>> database is stored?
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conrad...essjunkie.html
>>
>>
>>
>> "Julie" <(E-Mail Removed)> wrote in message
>> news:16B1419F-6271-4796-B420-(E-Mail Removed)...
>> > Hello.... I have a question that is related to this topic. I thought
>> > that
>> > I
>> > had security figured out on my database. The file is on a network
>> > server.
>> > I
>> > set myself up as a user with full permissions, and two others as
>> > "read-only."
>> > When I open the database (as a full permissions user), the other two
>> > users
>> > (read-only) are unable to open it. They get an error message: "Could
>> > not
>> > use 'Admin'; file already in use." Is this something that I can fix,
>> > or
>> > is
>> > that just the way it is?
>> > Thanks.
>> > --
>> > Julie
>> >
>> >
>> > "Keith" wrote:
>> >
>> >> "Help Me Please" <(E-Mail Removed)> wrote in
>> >> message
>> >> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
>> >> > Hi im looking to set the access rights to a database, i want 1 user
>> >> > to
>> >> > have
>> >> > full access rights ( a username and password) and the rest of them
>> >> > to
>> >> > have
>> >> > only read only access,
>> >> >
>> >> > Is this possible.
>> >> >
>> >> Yes but it is not straightforward. First you need to read and
>> >> understand
>> >> the Access security FAQ. There's a link to it on my web site but be
>> >> prepared for a steep learning curve and have patience. Most of all,
>> >> be
>> >> sure
>> >> to work on COPIES of your files in case you lock yourself out. Also,
>> >> don't
>> >> be tempted to skip bits of the FAQ, it's ALL relevant.
>> >>
>> >> Regards,
>> >> Keith.
>> >> www.keithwilby.com
>> >>
>> >>
>> >>
>>
>>
>>

Lynn:

I'm pretty sure.... in Access, under Tools, Security, Users &
Permissions.... when my username is highlighted, "open/exclusive" is
unchecked...
--
Julie


"Lynn Trapp" wrote:

> Julie,
> That's definitely a little odd then. Are you certain that you are not
> opening the database in exclusive mode?
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conrad...essjunkie.html
>
>
>
> "Julie" <(E-Mail Removed)> wrote in message
> news:2FF1E199-5385-4617-B2AC-(E-Mail Removed)...
> > Lynn:
> >
> > No... on the folder where the file is stored, the we all have full access.
> > I set up the "full permission" & "read-only" access from the user-security
> > wizard in Access.... The "read-only" users can open the file when I'm not
> > using it, but they can't open it when I have it open (full permission).
> > Thanks for your help.
> > --
> > Julie
> >
> >
> > "Lynn Trapp" wrote:
> >
> >> Julie,
> >> Do you mean "full permissions" and "read-only" on the folder where the
> >> database is stored?
> >>
> >> --
> >> Lynn Trapp
> >> MS Access MVP
> >> www.ltcomputerdesigns.com
> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> Jeff Conrad's Access Junkie List:
> >> http://home.bendbroadband.com/conrad...essjunkie.html
> >>
> >>
> >>
> >> "Julie" <(E-Mail Removed)> wrote in message
> >> news:16B1419F-6271-4796-B420-(E-Mail Removed)...
> >> > Hello.... I have a question that is related to this topic. I thought
> >> > that
> >> > I
> >> > had security figured out on my database. The file is on a network
> >> > server.
> >> > I
> >> > set myself up as a user with full permissions, and two others as
> >> > "read-only."
> >> > When I open the database (as a full permissions user), the other two
> >> > users
> >> > (read-only) are unable to open it. They get an error message: "Could
> >> > not
> >> > use 'Admin'; file already in use." Is this something that I can fix,
> >> > or
> >> > is
> >> > that just the way it is?
> >> > Thanks.
> >> > --
> >> > Julie
> >> >
> >> >
> >> > "Keith" wrote:
> >> >
> >> >> "Help Me Please" <(E-Mail Removed)> wrote in
> >> >> message
> >> >> news:B10BDA7E-5FF8-4A43-AAF9-(E-Mail Removed)...
> >> >> > Hi im looking to set the access rights to a database, i want 1 user
> >> >> > to
> >> >> > have
> >> >> > full access rights ( a username and password) and the rest of them
> >> >> > to
> >> >> > have
> >> >> > only read only access,
> >> >> >
> >> >> > Is this possible.
> >> >> >
> >> >> Yes but it is not straightforward. First you need to read and
> >> >> understand
> >> >> the Access security FAQ. There's a link to it on my web site but be
> >> >> prepared for a steep learning curve and have patience. Most of all,
> >> >> be
> >> >> sure
> >> >> to work on COPIES of your files in case you lock yourself out. Also,
> >> >> don't
> >> >> be tempted to skip bits of the FAQ, it's ALL relevant.
> >> >>
> >> >> Regards,
> >> >> Keith.
> >> >> www.keithwilby.com
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>