User and Group Permissions Problem - Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

I have designed a database which other people will access, so wanted to make
some forms read only for some people.

I decided to use the security wizard to enable User and Group Permissions.
This worked fine. However, I have since found that every database I open now
has the login box pop up (this is a side effect I didnt envision). On top of
this if I move my database to another folder or another PC, none of the other
logins work.

Im therefore hoping to undo this security setup and rethink the read only
problem, but cannot find a way of removing the security.

Any advice appreciated.

Thanks
 
JaB said:
Hi there

I have designed a database which other people will access, so wanted to
make
some forms read only for some people.

I decided to use the security wizard to enable User and Group Permissions.
This worked fine. However, I have since found that every database I open
now
has the login box pop up (this is a side effect I didnt envision). On top
of
this if I move my database to another folder or another PC, none of the
other
logins work.

Im therefore hoping to undo this security setup and rethink the read only
problem, but cannot find a way of removing the security.

Any advice appreciated.

Thanks
Click to expand...

The problem with the wizard is that it does stuff without telling you and
you gain no appreciation of how security works. So ... you can either undo
what you've done* by renaming the backup file that the wizard should have
made (I think it will be called filename.bak where filename is the name of
your mdb file) with an mdb extension or you can take the plunge and learn
how to use security.

There's a guide to security on my web site that will give you a flavour,
there's also a link to the MS FAQ which is the comprehensive guide.
Remember to always experiment on dummy files.

*You may also have to rejoin the default "system.mdw" workgroup.

HTH - Keith.
www.keithwilby.com
 
One thing you need to know about Access security is that it's always "ON".
The reason why it's invisible to most users is because Access invisibly logs
you in as the user "admin". Where's this account located? It's located in a
file called System.mdw. This file is the default workgroup file.

By default, when you open an mdb file, Access always connects you to this
workgroup file. The admin account is in this file and this account has
permission to do whatever you want (full permissions on all tables, queries,
etc.)...

The moment you run the security wizard, that's when things change. The
wizard adds a password to the admin account (or I believe the wizard asks you
to supply one, I don't remember). This is the condition that has to occur for
the login window to always appear. The moment the admin account has a
password, the login window will always appear. The trick is to know which
workgroup file you are connected to when you open an mdb file.

If you are connected to a workgroup file that has the admin account with no
password, Access will "attempt" to open the file without the login window. If
you are connected to a workgroup file that has the admin account WITH a
password, the login window will always appear.

If you don't want the login window to appear, make sure Access is connected
to a workgroup file that has an admin account with no password. Use the
Tools-->Security-->Workgroup Administrator menu to change workgroup. Then
open your mdb file.

If the mdb file was secured by someone, you won't be able to open the file
though (by design).

Hope this helps a little.
 
Back
Top