User Recognition In Access Without Login

[Kevin]

Hello,

I tried to put a shortcut on each user's desktop and used
following string when creating the shortcut,

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx /pwd:xxx

mdb and mdw files are all on LAN.

the shortcut that is created on development machine works
OK on development machine.
But when I created a shortcut on client machine by using
his username and password. It always pops up logon window
and it doesn't recognize the login information if I
entered username and password.

Does anyone have any idea on this?

Thanks so much.

 

[Joan Wild]

Hello,

I tried to put a shortcut on each user's desktop and used
following string when creating the shortcut,

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx /pwd:xxx

I don't think the colons are necessary, but you say it works on your
machine.

the shortcut that is created on development machine works
OK on development machine.
But when I created a shortcut on client machine by using
his username and password. It always pops up logon window
and it doesn't recognize the login information if I
entered username and password.

The password is case sensitive. Also, are you sure the user has a password
(it may be blank).

 

[Kevin]

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx /password:xxx

I tried above string (use password instead of psd). I got
an error message - The command-line you used to start
Microsoft Access Contains an option that Microsoft Access
doesn't recognize. But after I click OK, the db is opened
and with the right rights for that particular user.

If I user a space instead of colon, the error message will
pop up twice before opening db.

There is must be a format problem in the string. Does
anyone know how to fix it?

Thanks so much!


Thanks.

 

[Joan Wild]

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx /password:xxx

Try
"C:\Program Files\Microsoft Office\Office10\MSACCESS.exe" "my db path"
/WRKGRP "my-MDW-path" /user "xxx" /pwd "xxx"

 

[Kevin]

Unforturnately, it doesn't work.
But it works without having password in the string as
following.

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx

Thanks so much.

 

[Joan Wild]

Unforturnately, it doesn't work.
But it works without having password in the string as
following.

"C:\Program Files\Microsoft Office\Office10
\MSACCESS.exe" "my db path" /WRKGRP my-MDW-
path /user:xxx

I don't know what to suggest, as it works for me.

 

[Kevin]

The problem has been resloved after I changed a mapped
drive letter to the real server name in both mdb and mdw
files..

Thanks so much, Joan.