473,383 Members | 1,818 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

opening access from web page on the intranet

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
1 1775
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: tabonni | last post by:
Hi All I connected MS Exchange Server to MS Access database using Access link table function. I can open the database table and see the fields and data inside the link table. However, the table...
44
by: Carlos Andr?s | last post by:
Hi everybody. I've got a problem. I'd like to avoid opening a new window when you have pressed the shift key and you click in the left button of the mouse. I've tried the next solution, in the...
0
by: Dan | last post by:
Hello to all. Any knowledge that you might have one the following subject will be GREATLY appriciated. I am new to Access Pages and I can not get rid of the following errors when I open my...
6
by: contributions | last post by:
I have an access database on our intranet which when a link is clicked to open it the user is prompted with "Would you like to open the file or save it to your computer?". I would like this option...
5
by: Andy P via AccessMonster.com | last post by:
I am responsible for maintaining our departmental intranet pages at work. I would like to put a link from our website to a MS Access database which is held on our Network drive. The problem I...
1
by: kkrizl | last post by:
I've tried to research this problem, and I haven't been able to find any references to it. Probably because I shouldn't be doing it, but it was working, and now it's not. I'm trying to develop a...
7
by: =?Utf-8?B?a21jY29za2V5?= | last post by:
I'm trying to access an access database on the file server from a web server using asp.net and IIS 6.0. I can do it when I have anonymous access enabled in IIS 6.0 as in the public internet web...
15
by: anon | last post by:
I have a page where the ASP script create a table of links i.e. 1 = NextPage.asp?Item=1 2 = NextPage.asp?Item=2 etc What I would like to do is open an new window with this link without any...
6
by: qwerty9988 | last post by:
I have an INTRAnet web application and the users want to add a URL link to an access database that they use. They do not want to put the access database on the web, they just want to be able to open...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.