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.
LVL 1
gigo30Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.