Access database opened via Intranet - integration

[contributions]

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.

[Trevor Best]

co***********@theeyeguide.co.uk 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]

[Bob Alston]

Trevor Best wrote:

co***********@theeyeguide.co.uk 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

[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

[Bob Alston]

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

[OldManAccess]

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

[OldManAccess]

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.