accessman2
Registered User.
- Local time
- Today, 10:03
- Joined
- Sep 15, 2005
- Messages
- 335
Hi,
In the MS Access database, I let the user create the shortcut, and the shortcut have these values
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "\\share001\USERS\accessman\mdb\db1.mdb" /cmd "12345_p"
After that, the program will attach this shortcut to the email, and then send it to the manager.
Here is a question. When the manager have the same path MSACCESS.EXE, and have access the file on the sharing drive, then he can open it, and goto specific record depend on the /cmd.
If the manager's MS Access path is not same the input user's one, then the manager cannot open it.
I want to make the shortcut more flexible, and more efficiently.
Can we make the shortcut with these values only,
"\\share001\USERS\accessman\mdb\db1.mdb" /cmd "12345_p"
when the manager open this shortcut, the program can still open it and goto specific record. I tried it before, it just open it, but it does't goto specific record, because I remove MSACCESS.exe path in the shortcut.
Because when the manager work another computer, the MSACCESS.exe could be different, then the shortcut cannot be used anymore. And, I don't want the manager manually modify the shortcut values, because they don't know, and don't like to do it.
So, currently, I am figuring out how we can create good shortcut.
Does anybody have suggestion?
In the MS Access database, I let the user create the shortcut, and the shortcut have these values
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "\\share001\USERS\accessman\mdb\db1.mdb" /cmd "12345_p"
After that, the program will attach this shortcut to the email, and then send it to the manager.
Here is a question. When the manager have the same path MSACCESS.EXE, and have access the file on the sharing drive, then he can open it, and goto specific record depend on the /cmd.
If the manager's MS Access path is not same the input user's one, then the manager cannot open it.
I want to make the shortcut more flexible, and more efficiently.
Can we make the shortcut with these values only,
"\\share001\USERS\accessman\mdb\db1.mdb" /cmd "12345_p"
when the manager open this shortcut, the program can still open it and goto specific record. I tried it before, it just open it, but it does't goto specific record, because I remove MSACCESS.exe path in the shortcut.
Because when the manager work another computer, the MSACCESS.exe could be different, then the shortcut cannot be used anymore. And, I don't want the manager manually modify the shortcut values, because they don't know, and don't like to do it.
So, currently, I am figuring out how we can create good shortcut.
Does anybody have suggestion?
