Always login prompt in Access

[Soegstad]

I really need some help guys.
For some reason Access always asks for a login/password even if the database isn't protected. Even when I start a brand new database the prompt comes up. Any ideas as to how to get rid of this.

 

[Len Boorman]

Suspect that when security was set on a database the System.mdw file was used. This you never do.

Alternatively
You have opened a secured database and joined the appropriate workgroup. When closeing you have not rejoined the default group

If you are feeling good find and start wrkgadm.exe and join the system workgroup.

If you still have the problem then the system.mdw has been used for setting security and basically you need to
a) Create an unsecured version of the secured database
b) replace the system.mdw with a clean copy
c) reset the security properly

tweaingk the shortcut that fires the secured version so that you join and exit the appropriate workgroup will need to be done whatever the situation. Send me a PM with a valid email address and I have some documents that I can send that should help

Len

 

[Smart]

If you are using msaccess 2000

C:\programfiles\microsoft office\office\1033\wrkgadm.exe

double click on wrkgadm.exe
join
browse
crogram files\microsoft office\office\system

click on system
click on open

That should solve the problem