We have a new user who is unable to get into a database. Another user in the same office had no problems.
The other user is using:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" /wrkgrp"\\ServerName\ShareName\SFTP\SFTPWorkgroup.mdw" "C:\SFTP Database V2.1 FE\SFTP Database V2.1 FE.mdb
The new user was not able to access the share at all using \\ServerName\ShareName\SFTP until he changed the path to:
"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" /wrkgrp"\\ServerName.ACCT05.us.companyabbreviation.com\Sha reName\SFTP\SFTPWorkgroup.mdw" "C:\SFTP Database V2.1 FE\SFTP Database V2.1 FE.mdb"
Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file \\ServerName.ACCT05.us.companyabbreviation.com\Sha reName\SFTP\SFTPWorkgroup.mdw 1" "C:\SFTP Database V2.1 FE\SFTP Database V2.1 FE.mdb" (Note the space and 1)
I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.
Does anyone have any thoughts? He is on the company network, even though he is in another city like the other user. This sounds like a network issue to me -- or maybe something with his computer.