Command-Line Switches in URL

[Kix_N_Grins]

Is it possible to include command-line switches in a URL that is emailed?

For example: file://c:/data.mdb /cmd "123"

I can get file://c:/data.mdb to open (excluding the switch), but can't seem to get the the switch to work. I include %20 to replace the spaces, still doesn't work.... I've also tried file//c:/data.lnk /cmd "123" and the link pointing to the actual mdb.

I'm trying to include the URL in an email that gets sent, and when the recipient clicks the URL, it opens a form and passes the 123 (to indicate the record number.

If the command-line switches are not an option, is it somehow possible to alter the Target and Startin options to a shortcut using VBA in order to adjust the command-line switch (I can always then attach the altered icon to an email).

Thanks in advance for any help.

 

[ByteMyzer]

The command line options do not work unless you call Microsoft Access directly, with the database's file path as one of the command line arguments.

This does not work:

c:\data.mdb /cmd "123"

This works:

"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" c:\data.mdb /cmd "123"

NOTE: The actual path to Microsoft Access may vary, depending on the installation, version, etc.

Considering that you hope to accomplish this in an Emailed URL, this may not be a feasible option unless the URL is taylored to the Email recipient's specific Microsoft Access installation file path.