Collapse of User-Level Security!!

[Guest]

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??

 

[Guest]

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?

 

[Douglas J. Steele]

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/access/content/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.

 

[Joseph Meehan]

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.

 

[Rob Oldfield]

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.

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

 

[Joseph Meehan]

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.

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.

 

[Rob Oldfield]

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.

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.