Security/Permissions questions ACC 2000

[David Ingram]

Greetings all!

I am aiming to set up simple permissions for users on a database here
at work, to the effect that certain users should be restricted from
opening certain forms and reports. I tried setting up groups and
permissions, but found that users were still able to open forms I had
thought would have been restricted. I then tried the security wizard,
and found that TOO restrictive, especially if I find another job and
am not around to help if problems come up later on.

So, two questions:

1. Shouldn't setting passwords and permissions, WITHOUT the security
wizard, restrict users in the manner I'd expected? If not, why not?

2. Now that I've removed the password for the Admin account and can
get into all databases without passwords again, is it safe to delete
the Secured.mdw file, along with the database I'd attempted to secure
using the wizard?

FYI, after running the security wizard, I was unable to get into the
secured database, but could get into other databases using the proper
password.

Thanks all!

David Ingram
da********@earthlink.net

[Tom van Stiphout]

On 5 Apr 2004 09:35:17 -0700, da********@earthlink.net (David Ingram)
wrote:

It's been said here so many times, it's surprising you haven't heard
it yet: Access security is an advanced topic. Download, study, and
fully understand the Access security faq from microsoft.com. Anything
else will cause grief in the long run.

-Tom.

Greetings all!

I am aiming to set up simple permissions for users on a database here
at work, to the effect that certain users should be restricted from
opening certain forms and reports. I tried setting up groups and
permissions, but found that users were still able to open forms I had
thought would have been restricted. I then tried the security wizard,
and found that TOO restrictive, especially if I find another job and
am not around to help if problems come up later on.

So, two questions:

1. Shouldn't setting passwords and permissions, WITHOUT the security
wizard, restrict users in the manner I'd expected? If not, why not?

2. Now that I've removed the password for the Admin account and can
get into all databases without passwords again, is it safe to delete
the Secured.mdw file, along with the database I'd attempted to secure
using the wizard?

FYI, after running the security wizard, I was unable to get into the
secured database, but could get into other databases using the proper
password.

Thanks all!

David Ingram
da********@earthlink.net

[David Ingram]

Yes, perhaps after having posted my question (perhaps not?) I followed
this advice and am beginning to read through the FAQ now. However,
it's interesting to note that I seem to remember having set up
permissions/restrictions on Access databases in the past, and it was a
simple matter of establishing passwords and defining permissions.

I had hoped that perhaps the Workgroup ID-related stuff might have
been a "more advanced" version of security, and that there might be a
more "for idiots" security version I could quickly master.

I'm sure that either I'm remembering wrongly or the version of Access
that I last "secured" was based on an older paradigm long since
abandoned as ineffective. Or maybe it was considered for wimps? Too
easy?

At any rate, if anyone can weigh in with an even-more-basic
distillation of the nuts and bolts of the process it would be most
helpful! Any recollections of past versions wherein the process was
indeed much simpler? Or am I crazy?

Thanks!

David Ingram
da********@earthlink.net

Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<g6********************************@4ax.com>. ..

On 5 Apr 2004 09:35:17 -0700, da********@earthlink.net (David Ingram)
wrote:

It's been said here so many times, it's surprising you haven't heard
it yet: Access security is an advanced topic. Download, study, and
fully understand the Access security faq from microsoft.com. Anything
else will cause grief in the long run.

-Tom.

Greetings all!

I am aiming to set up simple permissions for users on a database here
at work, to the effect that certain users should be restricted from
opening certain forms and reports. I tried setting up groups and
permissions, but found that users were still able to open forms I had
thought would have been restricted. I then tried the security wizard,
and found that TOO restrictive, especially if I find another job and
am not around to help if problems come up later on.

So, two questions:

1. Shouldn't setting passwords and permissions, WITHOUT the security
wizard, restrict users in the manner I'd expected? If not, why not?

2. Now that I've removed the password for the Admin account and can
get into all databases without passwords again, is it safe to delete
the Secured.mdw file, along with the database I'd attempted to secure
using the wizard?

FYI, after running the security wizard, I was unable to get into the
secured database, but could get into other databases using the proper
password.

Thanks all!

David Ingram
da********@earthlink.net