Re: opening access database (.mdb) file issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Jul 11, 11:22 pm, "Jon Kennedy" <jkenne...@xxxxxxxxxxxxxxx> wrote:
See this article for possible help:

Executing files by hyperlink and the File Download dialog box in Internet
Explorerhttp://support.microsoft.com/kb/232077/en-us

--

Jon R. Kennedy MS MVP/IE
Charlotte, NC USA
jkenne...@xxxxxxxxxxxxxxx

<lane.ja...@xxxxxxxxx> wrote in message

news:1184206507.385466.274780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I'm not sure if this is the correct group, but anyway...

At work I have set up a web-based intranet (using the drupal cms).
I want would like to launch an Access Database which resides on a
networked drive via a hyperlink.
The link looks something like:
<code>
<a href="file://\P:\path\to\mdbfile.mdb">open db</a>
</code>
When I click on this link, I get two messages. The first asks if I
want to open or download the DB.
If I select open, I get a security message that says something like:
"...the file you are downloading cannot be opened by the default
program."
And then I cannot simply open the DB, but must download it.

However, if i simply type the path ("file://\P:\path\to\mdbfile.mdb")
into IE's address field, the DB launches as desired.

How can I get this same behavior via a hyperlink?

Jon,
Thank you for the useful response.
I have a few additional question:
1) is there a way to change the folder view option so the iFrame
displays the files in the list view and removes the directory's left
sidebar?
2) do you know of a way, maybe using javascript, to create a regular
hyperlink which directs a user to a webpage that contains this iFrame
and then automatically double-clicks the appropriate file. I envision
a scenario where all of the files I want users to launch via our
intranet are organized (via shortcuts) into one directory. A user
would click a link on our Intranet that directs them to a web page
that contains an iframe with this directory but instead of forcing
them to double-click on the appropriate file, a javascript onload
event would take a variable from the URL to identify the specific file
to launch and then automatically double-click it.

Also, the article you directed me to suggests that "there is nothing
in the HTML specification for the anchor tag (<A>) or any current
scripting object model that provides a means for the Web site to
indicate which is desired for a particular link."
However, using javascript, you can execute an .exe file from the
browser using something like:
function RunEXE()
{
var oShell = new ActiveXObject("WScript.Shell");
var prog = "p:\\path\\to\\db.mdb";
oShell.Run('"'+prog+'"',1,true);
}

Where the following can be a button (or hyperlink).
<input id="Button1" onclick="RunEXE()" type="button" />

The problem here is that I need to change all my users IE security
settings to enable "Initializing and Script Activex controls not
marked as safe".

Thanks again,
-Jacob


.



Relevant Pages

  • opening access database (.mdb) file issue
    ... I want would like to launch an Access Database which resides on a ... I get a security message that says something like: ... And then I cannot simply open the DB, but must download it. ... How can I get this same behavior via a hyperlink? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: opening access database (.mdb) file issue
    ... Executing files by hyperlink and the File Download dialog box in Internet ... Jon R. Kennedy MS MVP/IE ... I want would like to launch an Access Database which resides on a ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Submit Button Hyperlink
    ... fired up my long lost ftp client and began a download. ... I think the form action and the hyperlink you've wrapped it with is causing ... > and this works if typed into the address bar. ...
    (microsoft.public.frontpage.client)
  • Re: Hyperlink in Office 2007
    ... hyperlink properly. ... file thats named in the documents properties location. ... as such the download will not work. ... The problem is that those hyperlinks are pointing to my Temp folder on the ...
    (microsoft.public.word.docmanagement)
  • Re: Force Downloading of File
    ... If the DWG is defined then change it. ... > download" applet to download to my harddrive. ... I'm not sure how IE6 goes ... > this when this page or hyperlink is being accessed to force it to go to the ...
    (microsoft.public.frontpage.programming)