Re: All databases including new ones require password!

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks. Removing the System.mdw file was exactly what I needed to do. And
I thought at the time that I was following explicit step by step
instructions that i found on the web.

Thanks again and I will be more careful in the future.

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:a19wf.53311$q%.33541@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> BEP wrote:
> > Reinstalling Access did not solve the problem either.
> >
> > BEP
>
> Whether you are asked for a user name and password by Access is NOT
determined
> by which file you are opening. It is determined by which workgroup file
is
> being used by the Access session. If the workgroup being used has a
password on
> the default user "Admin" then you are prompted to log in. If it does not
then
> you are not prompted.
>
> When you were messing with security you must have changed your default
workgroup
> file to one that has a password on the Admin user. You need to use the
> workgroup administator utility to change your default back to System.mdw.
>
> If you were foolish enough to apply a password to the Admin user in the
> System.mdw workgroup file, then you have to log in with that password and
then
> clear the password once in. Otherwise you could delete that file and then
open
> Access without specifying any file. When it cannot locate System.mdw it
will
> create a new one. The new one will not have a password on the Admin user
and
> you would be back to normal.
>
> Accesss User Level Security is an advanced topic and you cannot learn it
or
> apply it successfully by experimentation. You need to follow an explicit
step
> by step set of instructions to have any chance of getting it right. A
search of
> the web will turn up such documents easily.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>


.

Relevant Pages

  • Re: Workgroup Question
    ... How can I delete a workgroup all together. ... it isn't necessary to remove the permissions from the Admins Group ... Admin user has a pwd in place. ... Permissions are stored in the database file itself. ...
    (microsoft.public.access.security)
  • RE: Mystery security group setting changes.
    ... The .mdw file I use for this workgroup is called "share.mdw" and the default ... Sometimes when there are updates, ... suddenly the Admin user rejoined the ADMINS group within share.mdw. ...
    (microsoft.public.access.security)
  • Re: Always asked to login, and I cant!
    ... This is known as a "secure" workgroup. ... The default Admin user most definitely has a password, ... if you want to open or create a database file. ...
    (microsoft.public.access.security)
  • Re: Multiple User Security
    ... set up a workgroup security file. ... Remove the Admin user from the Admins group, ... Don't set permissions on individual users, ...
    (microsoft.public.access.security)