command line to open access database is not working when used wit.

[mikedevelop]

I coverted an application from 97 to 2003. In this application access
database is being open thru a command line using an account username and
password. An error is ocurring when this line is being executed. Access is
reponding that check the file name however, this was discarted since when the
line is execute without the username/password the database is opened. Do I
have to istall other components?

 

['69 Camaro]

Hi.

Do I
have to istall other components?

No. The command to open the database is missing some information. The full
syntax is (watch out for word wrap -- it should all be one line):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW" /user myUser /pwd myPassword

This can be typed on the command line or saved as the Target Property in a
Windows shortcut. For security reasons, the User ID and password
_should_not_ be saved in the shortcut itself. If these two items are left
out, then the user will be prompted for the User ID and password when Access
opens.

Alternatively, the user can join the secured workgroup with the Access
Workgroup Administrator, then open the database with the command line or
shortcut that doesn't include the workgroup, User ID or password, and then
provide the User ID and password when prompted.

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.)

 

[jim]

Check the path to office 2003 stuff. The msaccess.exe is
in Office11 directory.

Jim