Open MS Access with parameters

Question

Hello,

From an Access DB, I try to send an e-mail (Outlook) with a link to a specific form and a specific record.
here is the command line:

Z:\Test\MyDB.accdb /cmd "1 155"

(where 1 is the form nr and 155 the record nr)

When testing it with the Windows run, it works perfectly: it opens my DB and I am on the right form on the right record.
My problem is to integrate this command line in an e-mail: I try to create an hyperlink but I am blocked with the "/" in front of cmd. I cannot put it in the link (try to test it in Word): it is always transformed into a "\" and the link is no more recognised.

I already tried to add quotes without success

Any solution?

Thank you

Answer 1

Hello,

Do you insert hyperlink in mail body and set its address into Z:\Test\MyDB.accdb /cmd "1 155" ? AFAIK, Office does not support command line switches in hyperlink address. You may create a .bat or short cut to run the command line and then link to the .bat or .exe

Please visit the similar threads:

https://superuser.com/questions/492765/excel-2010-hyperlink-how-to-call-a-file-with-command-line-arguments-and-space

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_other/how-to-create-a-hyperlink-in-word-calling-an/12d7ef7d-900f-4140-891b-00c50cc42717?auth=1

Regards,

Celeste

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].