• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Access command-line login won't work

I have win 98 and Access 97. I made a shortcut to start Access with a certain Access username and password. But the Access login box always comes up. I thought if I specified the password on the command line the Access login would not appear. Here is my command line:

"C:\Program Files\office97\Office\MSACCESS.EXE" c:\smswork\access97\percep00.mdb  /nostartup /user survey /pwd 5415

And yes I did create this user in the MDW file with that password.
0
gigo30
Asked:
gigo30
  • 4
  • 4
1 Solution
 
AngieBCommented:
There is nothing at all wrong with that command line as far as syntax is concerned - the only thing you might want to try is putting quotes around the user name and pwd i.e. /user "survey" /pwd "5415".

Rgds, Angela
0
 
gigo30Author Commented:
Tried quotes, didn't work. I get an error "Invalid user or password."

I'm even specifying the workgroup file which has this user in it. I've also tried:
"C:\Program Files\office97\Office\MSACCESS.EXE" c:\smswork\access97\percep00.mdb  /wrkgrp o:\tveds\access\system8.mdw /nostartup /user "Survey" /pwd "5415"

Sheesh! This should be so simple!
0
 
gigo30Author Commented:
Tried quotes, didn't work. I get an error "Invalid user or password."

I'm even specifying the workgroup file which has this user in it. I've also tried:
"C:\Program Files\office97\Office\MSACCESS.EXE" c:\smswork\access97\percep00.mdb  /wrkgrp o:\tveds\access\system8.mdw /nostartup /user "Survey" /pwd "5415"

Sheesh! This should be so simple!
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
AngieBCommented:
Mine works with or without quotes!!!!

Are you able to login manually if you remove /pwd  ?
0
 
gigo30Author Commented:
Uh, yes. Does that mean my password didn't take?
0
 
Jeremy_DCommented:
Try it WITHOUT the quotes, but WITH the /wrkgrp option (check the path!) and it should work fine.
0
 
AngieBCommented:
it does look like the password is causing the problem - just as a test, can you change the password to a text string then try that...
Shouldn't make any difference but 'hey' this is Microsoft we're talking about :)
0
 
gigo30Author Commented:
I did that but it didn't work. AngieB, submit an answer and I'll close this question. You were the closest in helping me.

0
 
AngieBCommented:
Sorry that didn't work...
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now