Re: Locked out

I was able to resolve the problem by just setting the macro security to low.
Now I can open my databases without Access prompting me for a username and
password. Whats the significance of this?

"Rick B" wrote:

> It sounds like you have setup a password for the ADMIN user in your default
> workgroup.
>
> You will either need to enter the password, or recreate your workgroup file.
> If you don't have a backup, you can actually delete (or move safely to
> another folder) the system.mdw. When you start Access it will build a new
> one. I believe this may prompt you for the install disks in some cases, so
> make sure you have them handy.
>
> --
> Rick B
>
>
>
> "neeraj" <neeraj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2F6117FA-2F63-47FB-8CCF-5DD7BCC1F8E5@xxxxxxxxxxxxxxxx
> > I have been working on security in the past few days. I had been working
> in
> > an Access database today and it was working fine without my requiring to
> > provide any username and password. I closed it and opened another in the
> same
> > directory and it is asking for username and password which it seems I dont
> > know. Now it requires username and password for all databases including
> the
> > one which did not require one this morning. Interestingly, I did not make
> any
> > changes to my security settings today and yet this problem occured. After
> > this problem occured, I have tried setting my workgroup information file
> to
> > the system provided, that is system.mdw and yet it asks for a username and
> > password for all databases. Please help as I cant open any database on my
> > computer.
>
>
>
.

Relevant Pages

  • Re: Password Activated Although Never Set
    ... Are you prompted for just a password, or for a username and password? ... in which case you are joined by default to your secure mdw. ... :I have two databases and set a password on one of them. ... security as it is not a database on which security is needed. ...
    (microsoft.public.access.security)
  • Re: Can not open database
    ... username and password, I never setup security on these databases. ... > Is it possible that since I had to change my domain login password, ...
    (microsoft.public.access.security)
  • Re: Pervasive SQL Help
    ... Security is implemented on a database-by-database basis, ... security from the databases. ... Post titled Pervasive SQL 9.5 Security Problems, ... "DBA" for a retail chain with 350+ stores, each of which had a PSQL ...
    (comp.databases.btrieve)
  • Re: How to remove Security from Access 2002
    ... Just back in the office today, your advice worked perfectly, thanks very ... databases, and vba but not much more advanced than that. ... "Joan Wild" wrote: ... Open Access and go to Tools, Security, Workgroup ...
    (microsoft.public.access.security)
  • Re: How to remove Security from Access 2002
    ... However, since you are joined by default to your secure mdw, that is what ... set up on my home MS Access databases so this one should be ... Open Access and go to Tools, Security, Workgroup ... Rejoin the standard system.mdw workgroup file. ...
    (microsoft.public.access.security)