Group:  English: General ยป microsoft.public.windows.inetexplorer.ie6.browser
Thread: opening access database (.mdb) file issue

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

opening access database (.mdb) file issue
lane.jacob[ at ]gmail.com 12.07.2007 02:15:07
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?

Re: opening access database (.mdb) file issue
"Jon Kennedy" <jkennedy2[ at ]carolina.rr.com> 12.07.2007 03:22:44
See this article for possible help:

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

--

Jon R. Kennedy MS MVP/IE
Charlotte, NC USA
jkennedy2[ at ]carolina.rr.com


<lane.jacob[ at ]gmail.com> wrote in message
news:1184206507.385466.274780[ at ]n60g2000hse.googlegroups.com...
[Quoted Text]
> 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?
>


Re: opening access database (.mdb) file issue
lane.jacob[ at ]gmail.com 12.07.2007 12:09:38
On Jul 11, 11:22 pm, "Jon Kennedy" <jkenne...[ at ]carolina.rr.com> wrote:
[Quoted Text]
> 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...[ at ]carolina.rr.com
>
> <lane.ja...[ at ]gmail.com> wrote in message
>
> news:1184206507.385466.274780[ at ]n60g2000hse.googlegroups.com...
>
> > 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


Re: opening access database (.mdb) file issue
"Jon Kennedy" <jkennedy2[ at ]carolina.rr.com> 13.07.2007 01:24:50
The answer to your first two questions is, and I'm sorry, no - I don't do
coding. Hopefully someone smarter than me in that area will come along and
answer correctly. As for your last question, that setting can be made for
all your users by using a Group Policy - Computer Config...Admin.
templates....Windows Components....Internet Explorer...Internet Control
Panel...Security Page. Or you can distribute and manage IE via the IEAK
http://technet.microsoft.com/en-us/ie/bb219517.aspx
--

Jon R. Kennedy MS MVP/IE
Charlotte, NC USA
jkennedy2[ at ]carolina.rr.com


<lane.jacob[ at ]gmail.com> wrote in message
news:1184242178.750850.225730[ at ]d55g2000hsg.googlegroups.com...
[Quoted Text]
>
> 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
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net