How come

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

Guest

if you setup a new user with a password and remove the user admin permissions
and leave password blank in your system.mdw, you don't get prompted for a
user / password when logging into new Access session? I understand what is
going on: system.mdw is trying to silently log you on as user admin and you
have no permission so you get denied. So youhave no way of logging in as the
new user unless you setup a shortcut or admin password. I think you should
be always prompted for a user / password instead of having to setup a
shortcut to login. It would be so much easier if you were 1. always prompted
to login (then you would always know who you logged in as) or 2. could click
on a menu like file - log in if at first you get denied. Why do you think???
 
MaBell said:
if you setup a new user with a password and remove the user admin
permissions and leave password blank in your system.mdw, you don't
get prompted for a user / password when logging into new Access
session?
Click to expand...

You must set a password for the Admin user to force the logon dialog to
display.

I understand what is going on: system.mdw is trying to
silently log you on as user admin and you have no permission so you
get denied. So youhave no way of logging in as the new user unless
you setup a shortcut or admin password. I think you should be always
prompted for a user / password instead of having to setup a shortcut
to login. It would be so much easier if you were 1. always prompted
to login (then you would always know who you logged in as) or 2.
could click on a menu like file - log in if at first you get denied.
Why do you think???
Click to expand...

Well, the vast majority of Access databases are not secured. I think most
would be annoyed at having to login when their database isn't secure.

Every session uses security - the system.mdw workgroup is used; it silently
logs you in as Admin, and this user owns all objects. The Users Group has
full permission on everything. Since everyone has system.mdw, and Admin and
the Users Group is common to all, it allows you to create a database and
givbe it to someone else, who will have not problem accessing/modifying the
database.

It's why, if you want to implement security, you remove all
permissions/ownership from the Admin user and the Users Group. It's also
why you create a new workgroup to secure your database (else the Admins
Group would be the same as well).

It is possible to secure your database, and not require a login, but only if
you have only 2 levels of security needed.
 
Back
Top