I have applied the user level security to my Access 2002 that is placed on
the newwork for multi users. Those who have copies of access 2002 or XP can
use the database in exactly the way I have defined the permissions.

Problem is with the users who have UPGRADED FROM ACCESS 97 TO ACCESS 2002.
These users totally bypass the security levels, as defined, and can do
whatever they with with the database. How can I control this??

I don't know if this has anything to do with your problem,but did you create
a new MDW for this database or did you use the default System.mdw to secure
it?
--
Bill Mosca


"Mark" wrote:

> I have applied the user level security to my Access 2002 that is placed on
> the newwork for multi users. Those who have copies of access 2002 or XP can
> use the database in exactly the way I have defined the permissions.
>
> Problem is with the users who have UPGRADED FROM ACCESS 97 TO ACCESS 2002.
> These users totally bypass the security levels, as defined, and can do
> whatever they with with the database. How can I control this??
>

If that's happening, then security wasn't properly applied in the first
place.

Get the Access Security FAQ at
http://support.microsoft.com/support...ent/secfaq.asp and try
resecuring your application, making sure you don't leave out any steps.

The most common mistake is forgetting to remove the Admin user from the
Admins group.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mark" <(E-Mail Removed)> wrote in message
news:AB7AEBE9-C6FF-4E31-9793-(E-Mail Removed)...
>I have applied the user level security to my Access 2002 that is placed on
> the newwork for multi users. Those who have copies of access 2002 or XP
> can
> use the database in exactly the way I have defined the permissions.
>
> Problem is with the users who have UPGRADED FROM ACCESS 97 TO ACCESS 2002.
> These users totally bypass the security levels, as defined, and can do
> whatever they with with the database. How can I control this??
>

Mark wrote:
>I have applied the user level security to my Access 2002 that is
> placed on the newwork for multi users. Those who have copies of
> access 2002 or XP can use the database in exactly the way I have
> defined the permissions.
>
> Problem is with the users who have UPGRADED FROM ACCESS 97 TO ACCESS
> 2002. These users totally bypass the security levels, as defined, and
> can do whatever they with with the database. How can I control this??

Your security was not properly set up to begin with.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

--
Joseph Meehan

Dia duit

"Joseph Meehan" <(E-Mail Removed)> wrote in message
news:qh6Lf.123022$(E-Mail Removed)...
> Mark wrote:
> >I have applied the user level security to my Access 2002 that is
> > placed on the newwork for multi users. Those who have copies of
> > access 2002 or XP can use the database in exactly the way I have
> > defined the permissions.
> >
> > Problem is with the users who have UPGRADED FROM ACCESS 97 TO ACCESS
> > 2002. These users totally bypass the security levels, as defined, and
> > can do whatever they with with the database. How can I control this??
>
> Your security was not properly set up to begin with.
>
> I suggest you start by reading
> http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
>
> Access security is a great feature, but it is, by nature a complex
product
> with a very steep learning curve. Properly used it offers very safe
> versatile protection and control. However a simple mistake can easily
lock
> you out of your database, which might require the paid services of a
> professional to help you get back in.
>
> Practice on some copies to make sure you know what you are doing.
>
> --
> Joseph Meehan
>
> Dia duit
>

I'd agree except for the word 'very'. It's not that good.

Rob Oldfield wrote:
> "Joseph Meehan" <(E-Mail Removed)> wrote in message
> news:qh6Lf.123022$(E-Mail Removed)...
>> Mark wrote:
>> >I have applied the user level security to my Access 2002 that is
>> > placed on the newwork for multi users. Those who have copies of
>> > access 2002 or XP can use the database in exactly the way I have
>> > defined the permissions.
>> >
>> > Problem is with the users who have UPGRADED FROM ACCESS 97 TO
>> > ACCESS 2002. These users totally bypass the security levels, as
>> > defined, and can do whatever they with with the database. How can
>> > I control this??
>>
>> Your security was not properly set up to begin with.
>>
>> I suggest you start by reading
>> http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
>>
>> Access security is a great feature, but it is, by nature a complex
>> product with a very steep learning curve. Properly used it offers
>> very safe versatile protection and control. However a simple
>> mistake can easily lock you out of your database, which might
>> require the paid services of a professional to help you get back in.
>>
>> Practice on some copies to make sure you know what you are doing.
>>
>> --
>> Joseph Meehan
>>
>> Dia duit
>>
>
> I'd agree except for the word 'very'. It's not that good.

I used "very" twice. :-)

I suspect you are talking about how secure it is. I say very secure
because if you don't do it right, you have locked yourself out and without
some serious help you are not likely to get back in. It also will protect
itself from 99.9% of the users out there that might be using it. However if
someone is reasonable knowledgeable and determined and wants to do their
homework, they can get through. I agree that it would not be the best thing
to secure truly confidential data that might be a target of someone who has
physical access to the data (including via LAN connection).

It is usually very good at keeping the office fool from getting in and
accidentally editing data or even seeing data.

--
Joseph Meehan

Dia duit

"Joseph Meehan" <(E-Mail Removed)> wrote in message
news:8o7Lf.94654$(E-Mail Removed)...
> Rob Oldfield wrote:
> > "Joseph Meehan" <(E-Mail Removed)> wrote in message
> > news:qh6Lf.123022$(E-Mail Removed)...
> >> Mark wrote:
> >> >I have applied the user level security to my Access 2002 that is
> >> > placed on the newwork for multi users. Those who have copies of
> >> > access 2002 or XP can use the database in exactly the way I have
> >> > defined the permissions.
> >> >
> >> > Problem is with the users who have UPGRADED FROM ACCESS 97 TO
> >> > ACCESS 2002. These users totally bypass the security levels, as
> >> > defined, and can do whatever they with with the database. How can
> >> > I control this??
> >>
> >> Your security was not properly set up to begin with.
> >>
> >> I suggest you start by reading
> >> http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
> >>
> >> Access security is a great feature, but it is, by nature a complex
> >> product with a very steep learning curve. Properly used it offers
> >> very safe versatile protection and control. However a simple
> >> mistake can easily lock you out of your database, which might
> >> require the paid services of a professional to help you get back in.
> >>
> >> Practice on some copies to make sure you know what you are doing.
> >>
> >> --
> >> Joseph Meehan
> >>
> >> Dia duit
> >>
> >
> > I'd agree except for the word 'very'. It's not that good.
>
> I used "very" twice. :-)
>
> I suspect you are talking about how secure it is. I say very secure
> because if you don't do it right, you have locked yourself out and without
> some serious help you are not likely to get back in. It also will protect
> itself from 99.9% of the users out there that might be using it. However
if
> someone is reasonable knowledgeable and determined and wants to do their
> homework, they can get through. I agree that it would not be the best
thing
> to secure truly confidential data that might be a target of someone who
has
> physical access to the data (including via LAN connection).
>
> It is usually very good at keeping the office fool from getting in and
> accidentally editing data or even seeing data.
>

Agreed. Think we're saying the same thing in slightly different ways.