468,733 Members | 1,206 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

Command Line Switch Password

I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /pwd "password:

The trouble is that when running this shortcut, it prompts first for a
Logon, asking for user name and password -- then it prompts for the database
password. (Two password prompts).

I am using very simple Access security -- no special user groups, etc...just
a simple password to open the MDB file. To solve, I tried the shortcut below
but it still does not work

I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /user "Admin" /pwd " "
/pwd "password:

How can I address this password issue?


Nov 12 '05 #1
3 10017
If the only password you want is the database password, make sure the Admin
user has no password, and Access will not ask for the workgroup logon, it
will simply start up as Admin.

On Wed, 22 Oct 2003 04:45:23 GMT, "Mike Wiseley" <mi**********@gte.net>
wrote:
I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /pwd "password:

The trouble is that when running this shortcut, it prompts first for a
Logon, asking for user name and password -- then it prompts for the database
password. (Two password prompts).

I am using very simple Access security -- no special user groups, etc...just
a simple password to open the MDB file. To solve, I tried the shortcut below
but it still does not work

I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /user "Admin" /pwd " "
/pwd "password:

How can I address this password issue?


Nov 12 '05 #2
TC
If it is prompting first for a username/password, this means that someone
has assigned a password to the Admin user of the default workgroup
information file. Maybe try starting the database, supplying whatever
passwords are needed, then using Tools : Security (or whatever it is) to
remove the password from the Admin user.

HTH,
TC
"Mike Wiseley" <mi**********@gte.net> wrote in message
news:DX*******************@nwrddc02.gnilink.net...
I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /pwd "password:

The trouble is that when running this shortcut, it prompts first for a
Logon, asking for user name and password -- then it prompts for the database password. (Two password prompts).

I am using very simple Access security -- no special user groups, etc...just a simple password to open the MDB file. To solve, I tried the shortcut below but it still does not work

I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /user "Admin" /pwd " "
/pwd "password:

How can I address this password issue?

Nov 12 '05 #3
The /pwd switch is only used (in conjunction with the /user switch) when
Access security is implemented. It is not for the database password.

Once you put the /pwd switch, it needed the username, so it prompted you
with the dialog.

There is no switch for the database password.

--
Joan Wild
Microsoft Access MVP

"Mike Wiseley" <mi**********@gte.net> wrote in message
news:DX*******************@nwrddc02.gnilink.net...
I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /pwd "password:

The trouble is that when running this shortcut, it prompts first for a
Logon, asking for user name and password -- then it prompts for the database password. (Two password prompts).

I am using very simple Access security -- no special user groups, etc...just a simple password to open the MDB file. To solve, I tried the shortcut below but it still does not work

I created a desktop shortcut with "C:\Program Files\Microsoft
Office\MSAccess.exe" "C:\My Documents\CopyAToB.mdb" /user "Admin" /pwd " "
/pwd "password:

How can I address this password issue?

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Paul Deverson | last post: by
1 post views Thread by Michael Wiseley | last post: by
5 posts views Thread by randyelliott | last post: by
13 posts views Thread by Pieter Edelman | last post: by
1 post views Thread by CARIGAR | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.