By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Command Line Switch Password

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.