Opening DB that has DB password from Command Line

[Guest]

I need to open an MS2002 db using command line parameters. When I pass the db password via /pwd it does not open the db without inputting the db password. Is there any way I can pass the db password via a command line?

 

[Joan Wild]

No. The /pwd switch is used in conjunction with the /user switch to provide
username/password. It is not for the database password (and there is no
switch for the database password).


--
Joan Wild
Microsoft Access MVP

I need to open an MS2002 db using command line parameters. When I pass the

db password via /pwd it does not open the db without inputting the db
password. Is there any way I can pass the db password via a command line?

 

[Guest]

Just to confirm your posting.

There is no way to use the command line on an password protected database (Access 2002) and with out manually entering the password?

Was this something that was possible in the past? (e.g. Access 2.0 97) The reason that I ask is that there is documentation stating that you can simply use the switch /pwd and get into the database.

It just isn't clear if that documentation applies to the newer version of Access 2000, 2002, 2003 etc..

Apperently not

Thank you for you help.

 

[Rick Brandt]

Just to confirm your posting.

There is no way to use the command line on an password protected database

(Access 2002) and with out manually entering the password?

No.

Was this something that was possible in the past? (e.g. Access 2.0 97)

The reason that I ask is that there is documentation stating that you can
simply use the switch /pwd and get into the database.

It has always been this way. The /pwd switch is for User Level security
not the database password feature.

The database paswword is so easy to break I suggest getting rid of it to
solve your problem.

 

[Joan Wild]

There has never been a switch to supply the database password. Some KB
articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;161177&Product=acc
http://support.microsoft.com/default.aspx?scid=kb;en-us;207891&Product=acc
http://support.microsoft.com/default.aspx?scid=kb;en-us;292302&Product=acc

You could use automation to do it
http://support.microsoft.com/default.aspx?scid=kb;en-us;235422&Product=acc
http://support.microsoft.com/default.aspx?scid=kb;en-us;209953&Product=acc

--
Joan Wild
Microsoft Access MVP

Just to confirm your posting.

There is no way to use the command line on an password protected database

(Access 2002) and with out manually entering the password?

Was this something that was possible in the past? (e.g. Access 2.0 97)

The reason that I ask is that there is documentation stating that you can
simply use the switch /pwd and get into the database.