473,785 Members | 2,844 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access database opened via Intranet - integration

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 bypassed as
some users become confused at this stage!

Also, is there a way to set the database to open within the browser
(IE6) in the same way that Excel and Word do - I'd like it to feel more
integrated to the Intranet than opening in a new window and
application.

Thanks in advance.

Nov 13 '05 #1
6 2779
co***********@t heeyeguide.co.u k wrote:
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 bypassed as
some users become confused at this stage!
Isn't that an option in IE? Some "don't ask me again" checkbox on that
dialog. How about a message on the page telling the user to select
"open" if prompted?
Also, is there a way to set the database to open within the browser
(IE6) in the same way that Excel and Word do - I'd like it to feel more
integrated to the Intranet than opening in a new window and
application.


PMSL
Wouldn't we all? :-)

You could investigate DAPs if you can get them to work, this may work if
you're forms aren't overly complex.

--
[OO=00=OO]
Nov 13 '05 #2
Trevor Best wrote:
co***********@t heeyeguide.co.u k wrote:
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 bypassed as
some users become confused at this stage!

Isn't that an option in IE? Some "don't ask me again" checkbox on that
dialog. How about a message on the page telling the user to select
"open" if prompted?
Also, is there a way to set the database to open within the browser
(IE6) in the same way that Excel and Word do - I'd like it to feel more
integrated to the Intranet than opening in a new window and
application.

PMSL
Wouldn't we all? :-)

You could investigate DAPs if you can get them to work, this may work if
you're forms aren't overly complex.

You don't normally access an Access database on via a web browser.
Suggest you just provide a network mapping to the location of the file
on the network.

Bob
Nov 13 '05 #3
rjs
It may not be normal to access an Access Database from a browser but we
try to direct staff to info all via our Intranet so would rather not
move backwards to desktop icons.

Could you elaborate on what DAPs are?

Thanks

Nov 13 '05 #4
rjs wrote:
It may not be normal to access an Access Database from a browser but we
try to direct staff to info all via our Intranet so would rather not
move backwards to desktop icons.

Could you elaborate on what DAPs are?

Thanks

If you don't want to move backwards to desktop icons, suggest you try to
use intranet properly. What you are doing Access was not indended to
do. You are using the web browser to find the file <databasename>. mdb
Since it is not a web page, the browser can only download it or turn it
over to Windows to open it. At that point, it is no longer an intranet
application.

Data Access pages are web pages, which can be used on an intranet, which
are created by Access and access the Access MDB for data. These work in
intranet situations but not in internet situations (due to security
problems).
You could learn a bit more about DAPs by reading my web posting on my
experience with them.
http://members.cox.net/tulsaalstons/...20Internet.htm

Try creating a simple DAP first.

Bob
Nov 13 '05 #5


rjs wrote:
It may not be normal to access an Access Database from a browser but we
try to direct staff to info all via our Intranet so would rather not
move backwards to desktop icons.

Could you elaborate on what DAPs are?

Thanks


Nov 13 '05 #6
These are all kind of quick answers:

DAP is a web page built by Access to open in a browser. They are
created, edited, and saved in your Data Access Pages tab on the
database window.
It can be interactive or it can be static (a form or report)
The database must be available from the browser - if you will be using
an intranet, it needs to be in the folders with the pages.
Once created, you can edit the html for style and tags.

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1640
by: John Baker | last post by:
Hi: I have a small project pending where I need to have a data base on our ISPs server and a web interface to the database. At periodic intervals, I want to be able to either interrogate the data base from a local system OR have the web based system transmit an e mail containing critical database information. Its not a big project, but could get messy. Does anyone have a suggestions for the right package to use to integrate a small...
33
5953
by: Uwe Range | last post by:
Hi to all! A customer of mine told me some days ago that her IT-people told her ACCESS would not be such a good idea for continuing with our project, because Access will not be continued in the future. I haven't heard of this. Does anybody know more about it? The IT-People usually prefer Oracle. If they really want to go in this direction, could our Access-application (if continued) be used as a front end with an Oracle back end? Does...
5
2000
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 have is that if Access has the startup properties set to display a form, MS Access doesn't start (it appears in the processes window in task manager but not in applications). If I change the startup properties so that no form is opened and the...
0
3292
by: bettervssremoting | last post by:
To view the full article, please visit http://www.BetterVssRemoting.com Better VSS Remote Access Tool including SourceOffSite, SourceAnyWhere and VSS Remoting This article makes a detailed comparison among SourceAnyWhere, SourceOffSite, VSS Remoting and possible others.
0
1394
by: Spencer Lee | last post by:
I have encountered a very unique problem (for me): I created a data access page, with 3 levels of groups. I put the file on the web folder (intranet), and it seems like everything is working fine. However, the data access page, when opened from my computer, allows user to add new record to the page. When it is opened from other computer, the "add record" button is inactive. One thing I notice is that, the page has the "add record"...
37
5245
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why would you even continue to use Access as a backend when you have a much superior option in SQL express? What about as a future front-end development tool? Let's get serious. Microsoft continues to publish numerous articles and videos on how you...
5
6456
by: Stewart | last post by:
Hi there, I have an Access database, which contains the details of company staff and services. The plan is to extract data from this database onto our forthcoming Intranet (no inserting, updating or deleting at this point). The Intranet itself has been created in ASP.NET, using Microsoft Visual Web Developer 2005. My concern is that we will encounter a slow response when pulling data from this Access database across the network...
1
2047
by: GNoter | last post by:
Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2; they are not part of a domain. I have a third server, Server3, which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well as on the internal intranet. I can connect via the intranet because the DB file is on the same box from which the intranet is being served...
5
2236
by: novak | last post by:
hi list, since a couple of weeks we face a special "security" problem. neraly every ms-access database that is located on our net-drives cannot be opened. when clicking the document's icon, first, the warning message arises "open document - security message" - "Really open *.mdb ....?", second, when clicking "start" ms-access starts, but the mdb-file cannot be opened. message: "ms-access could not open the file ... The
0
9480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10153
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10093
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9952
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8976
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7500
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6740
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4053
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2880
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.