Prompting a username/password on a non-secured database

[Guest]

Hello,

I created a database that is password protected for some of the staff in my
department. I've also created other non-secured databases that they use on a
daily basis. My question is why are they being prompted to enter their
username/password on the non-secured databases? How can I turn it off or
prevent it from happening. The end-users are getting frustrated that they
have to enter their username/password for every single database.

Anyhelp is greatly appreciated.

Thanks,
Maria

 

['69 Camaro]

Hi, Maria.

The users are joined to a secure workgroup that has a password set for the
Admin user. For instructions on the steps necessary to join an unsecure
workgroup, please see the "How to open databases and only be prompted for
User ID and password for the secure databases" tip on this Web page:

http://www.access.qbuilt.com/html/security.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Rick Brandt]

Hello,

I created a database that is password protected for some of the staff
in my department. I've also created other non-secured databases that
they use on a daily basis. My question is why are they being
prompted to enter their username/password on the non-secured
databases? How can I turn it off or prevent it from happening. The
end-users are getting frustrated that they have to enter their
username/password for every single database.

Anyhelp is greatly appreciated.

Thanks,
Maria

Access User-Level security is not "attached" to any particular file. Your
default workgroup file either has a password on the default user "Admin" or it
does not. In the case of the former you are prompted to logon. In the case of
the latter you are not prompted.

Change your user's default workgroup back to "System.mdw" so they are not
prompted when using their own files. Then create a shortcut to be used only to
open your secured file that specifies a non-default workgroup as a command line
argument. The target syntax will be roughly...

"Path to MSAccess.exe" /wrkgroup "Path the MDW file" "Path to MDB file"

 

[Tom Wickerath]

The target syntax will be roughly...

"Path to MSAccess.exe" /wrkgroup "Path the MDW file" "Path to MDB file"

Use /wrkgrp instead of "wrkgroup". See the following KB article:

How to use command-line switches in Microsoft Access
http://support.microsoft.com/?id=209207

Tom
_____________________________________

Hello,

I created a database that is password protected for some of the staff
in my department. I've also created other non-secured databases that
they use on a daily basis. My question is why are they being
prompted to enter their username/password on the non-secured
databases? How can I turn it off or prevent it from happening. The
end-users are getting frustrated that they have to enter their
username/password for every single database.

Anyhelp is greatly appreciated.

Thanks,
Maria

Access User-Level security is not "attached" to any particular file. Your
default workgroup file either has a password on the default user "Admin" or it
does not. In the case of the former you are prompted to logon. In the case of
the latter you are not prompted.

Change your user's default workgroup back to "System.mdw" so they are not
prompted when using their own files. Then create a shortcut to be used only to
open your secured file that specifies a non-default workgroup as a command line
argument. The target syntax will be roughly...

"Path to MSAccess.exe" /wrkgroup "Path the MDW file" "Path to MDB file"

 

[Guest]

Thanks to all who responded. I will try your suggestions.

Thanks again,
Maria