By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,163 Members | 934 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,163 IT Pros & Developers. It's quick & easy.

opening access from web page on the intranet

P: n/a
T
Currently there is an excel shortcut available on the network with
links to 30 or so access db (97 & 2003), since the users are
complaining about all the messages from excel (already open, do you
want to save etc), I thought about creating a html file that would
accomplish the same thing, exept now I get the message do you want to
save the file, and of course I don't. What is the quickest / easist
way to create an interface on the internet?

Thanks

Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 15 Aug 2007 15:51:33 -0700, T <te****@wideopenwest.comwrote:

How about this simple HTML page:
<html>
<h1>Don't try launching windows applications from a web page; use a
folder with shortcuts instead.</h1>
</html>

Another option is to use some client-side javascript and some
Automation code like this:
(this is opening Excel; adjust for opening Access)
var objXlApp = new ActiveXObject("Excel.Application");
objXlApp.Visible = true
var objXlWb = objXlApp.Workbooks.Open(strFile);
var objXlWs = objXlWb.Sheets("MySheet")
objXlWs.Select;
Note that the ActiveXObject call is for IE only.

-Tom.

>Currently there is an excel shortcut available on the network with
links to 30 or so access db (97 & 2003), since the users are
complaining about all the messages from excel (already open, do you
want to save etc), I thought about creating a html file that would
accomplish the same thing, exept now I get the message do you want to
save the file, and of course I don't. What is the quickest / easist
way to create an interface on the internet?

Thanks
Aug 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.