Command Line Switch Password

[Mike Wiseley]

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?

[Steve Jorgensen]

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?

[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?

[Joan Wild]

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?