Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old May 14th, 2002, 05:58 PM
mario.a.nunes mario.a.nunes is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: Porto,Portugal
Posts: 10 mario.a.nunes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Launch access application from web page

Hello again,

I am writing an intranet in ASP + javascript

I have an application server "\\MYSERVER" where there are several ACCESS applications (eg. "MYDB.MBD")

What i want to do is to write an HTML page to launch MYDB.MDB

Something like this:

<html>
...
<input type=button value="MY DB" onclick="launch('\\MYSERVER\MYFOLDER\mydb.mdb')">
...
</HTML>
<script language="Javascript">
function launc(sApp) {
window.open(sApp,...)
}
</script>

This code almost work.
The problem is that when i click the button, a input box opens asking me to save or open from that location.

Does anyone have a clue on how can i open the ACCESS application without any message?

Thanks.

Reply With Quote
  #2  
Old May 15th, 2002, 02:12 AM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
 
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 589 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Does the client have access to \\MYSERVER (i.e. are you on an intranet) or is it over the web? If it's on an intranet, then just open the access file in a new window, and if the client has access installed then it will load it automatically.

Reply With Quote
  #3  
Old May 15th, 2002, 06:40 PM
mario.a.nunes mario.a.nunes is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: Porto,Portugal
Posts: 10 mario.a.nunes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy

Hey mytch!

Yes, i'm on an intranet and the client has access to \\MYSERVER

I have two different situations:

1-window.open('\\MYSERVER\MYXLS.XLS',...)

2-window.open('\\MYSERVER\MYMDB.MDB',...)

The first one open automatically (no questions asked...)

The second open an input message where you have to choose between save to disk or open from that location.

What i would like to prevent is that anoying message, and always open from that location.

If you know something to work this out, let me know, please.

Thanks.

Reply With Quote
  #4  
Old May 15th, 2002, 06:47 PM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
 
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 589 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Hmmmm. You're going to be hard pressed finding a solution with JavaScript. It's to do with the header types that the access file is sending to the client.

I know this is a stupid question, but does the client PC have Microsoft Access installed on it?

Reply With Quote
  #5  
Old May 15th, 2002, 07:22 PM
mario.a.nunes mario.a.nunes is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: Porto,Portugal
Posts: 10 mario.a.nunes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Yes, the client has Office 2000 installed.

When i choose open from that location, the access starts and loads my application.

It's stupid...
I don't understand...
It works whit PDF, PPT, PPS, XLS, and so on...

But it doesn't work with MSACCESS!

I think Bill has enough money already.
he has no need to rush things any more...

Reply With Quote
  #6  
Old May 16th, 2002, 08:48 PM
Kiwi Kiwi is offline
Guru-in-training
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2002
Location: Not where I want to be...yet!
Posts: 38 Kiwi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
I'm not sure if there is a way around this that would rely solely on the scripting in the web page. You may need to change the settings in the user's browser. In IE, under Tools/Internet Options/Security, check Local Intranet and select custom level, and check that the setting for Miscellaneous/Access Data Sources Across Domains is set to Enable rather than Prompt.

Reply With Quote
  #7  
Old June 4th, 2002, 11:40 AM
Sparta Sparta is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Duluth
Posts: 5 Sparta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Try creating an autoexec in access and turn off options that allow you to open file.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Launch access application from web page


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT