a shortcut to a file on the local computer 1

[seaport]

I am building an Intranet and want to use it as a portal to all applications within the office.
I need to add some shortcuts to the Intranet page and these shortcuts point to some Access files or Excel files on users' computers (not on the Web server).
How can I do it?

Thanks in advance.

Seaport

 

[RISTMO]

Use a normal link with this form.

<a href=&quot;file:///C:/Documents%20and%20Settings/Administrator/My%20Documents/pages_to_do.xls&quot;>Docs & Setts</a>

This is a breakdown of how I got this and how you can do the same.

file:///C:/

This is the prefix--&quot;C&quot; can be any drive.

Documents%20and%20Settings/Administrator/My%20Documents/

The way to get this for any file--Use My Computer to go to the folder the file resides in, copy the url from the address bar, and if it contains spaces, replace each space with &quot;%20&quot;--without the quotes.

pages_to_do.xls

This is the actual filename of the Excel file. If you don't know it, you can get it by right-clicking on the file and choosing properties (at the very bottom). The filename should be at the top of the &quot;General&quot; tab.

Just add all the parts up in the format above, and it should work.

Rick -----------------------------------------------------------

http://www.ristmo.com/

RISTMO Designs

http://www.arabchurch.com/

Arab Church

 

[seaport]

Rick,

Thanks for your input. Your code works fine with Word and Excel, since both applications are integrated with IE.
However, this does not work with Access database. What the code does with Access databse is to download the target file directly from the local computer instead of from the Web site. A &quot;Download File&quot; message appears when I click the link.
I think I cannot bypass the message because it is a security feature of IE.

Seaport

 

[EdwardMartinIII]

seaport,

Are you able to set up a network location for these shared files?

I think there's a browser setting you can adjust so that it attempts-to-run a link, rather than prompt-for-download link, but I've not been able to figure it out.

If you're sharing an Access database, might I suggest making an MDE file of it and sharing the MDE file (which can be shared) instead of the MDB file (which cannot be opened by more than one person at a time)?

Cheers,
Edward

&quot;Cut a hole in the door. Hang a flap. Criminy, why didn't I think of this earlier?!&quot; -- inventor of the cat door