Linking Frontpage document to Access database?

[Darin Grimm]

We have built an internal information organization system using .htm pages created in frontpage that link to word documents. The user simply navigates the .htm pages with IE 6.0 and clicks the link or document name to view. This is working well -- however, we have an access database app that we would like to handle in the same fashion, but we are having problems

When clicking on the access app (actually the hperlink we have setup) we get a file download dialog box asking to either open or save the file, choosing open gives a blank page with nothing -- would like to aviod this dialog all together and simply open the app in the same way IE opens the word documents.

Ideas?

 

[Net55]

You can copy the tables to an Excel spread sheet and open
that in a browser. Or you can user FrontPage Database
Results Wizard to display and update the database.

Net55
[email protected]
http://www.frontpagewiz.com

-----Original Message-----
We have built an internal information organization system

using .htm pages created in frontpage that link to word
documents. The user simply navigates the .htm pages with
IE 6.0 and clicks the link or document name to view. This
is working well -- however, we have an access database app
that we would like to handle in the same fashion, but we
are having problems.

When clicking on the access app (actually the hperlink we

have setup) we get a file download dialog box asking to
either open or save the file, choosing open gives a blank
page with nothing -- would like to aviod this dialog all
together and simply open the app in the same way IE opens
the word documents..

 

[Darin Grimm]

Thanks for the reply. Our problem is that the Access mdb file is an app with forms/queries/reports already setup. I doubt we could create the interface we want using the frontpage database results wizard. After further research yesturday, it appears the problem is that excel and word documents are treated somewhat native to frontpage and when selected to the user it looks much like it does with windows explorer (document is opened). I can understand there will be a different set of issues with a database, but was hoping there was some way in either frontpage or through security settings, ect. in internet explorer to accomplish this -- The IE running on these machines will not have internet access, so no need to worry about settings affecting web browsing experiences

Dari


----- Net55 wrote: ----

You can copy the tables to an Excel spread sheet and open
that in a browser. Or you can user FrontPage Database
Results Wizard to display and update the database

Net5
[email protected]
http://www.frontpagewiz.co

-----Original Message----
We have built an internal information organization system

using .htm pages created in frontpage that link to word
documents. The user simply navigates the .htm pages with
IE 6.0 and clicks the link or document name to view. This
is working well -- however, we have an access database app
that we would like to handle in the same fashion, but we
are having problemshave setup) we get a file download dialog box asking to
either open or save the file, choosing open gives a blank
page with nothing -- would like to aviod this dialog all
together and simply open the app in the same way IE opens
the word documents.

 

[Andrew Murray]

you can actually modify the layout of the results between the beginning and end
results region....

See these examples:

http://www.applecross.perth.anglican.org/computer.asp
http://www.southern.perth.anglican.org/clergysearch.asp
http://www.southern.perth.anglican.org/chaplaincies.asp

they were all done with the results wizard in frontpage.

Yes, I agree most of it is limited in what you can do, but all you want is to
pull data from the database and display it right - how fancy do you actually need
it?

You can probably transfer your queries (copy/paste) etc to ASP pages, or does
the latest version of Access actually create any Html/ASP pages based on the
queries you write in SQL?

Thanks for the reply. Our problem is that the Access mdb file is an app with

forms/queries/reports already setup. I doubt we could create the interface we
want using the frontpage database results wizard. After further research
yesturday, it appears the problem is that excel and word documents are treated
somewhat native to frontpage and when selected to the user it looks much like it
does with windows explorer (document is opened). I can understand there will be
a different set of issues with a database, but was hoping there was some way in
either frontpage or through security settings, ect. in internet explorer to
accomplish this -- The IE running on these machines will not have internet
access, so no need to worry about settings affecting web browsing experiences.

 

[Andrew Murray]

You can copy the tables to an Excel spread sheet and open
that in a browser. Or you can user FrontPage Database
Results Wizard to display and update the database.

Net55
[email protected]
http://www.frontpagewiz.com
using .htm pages created in frontpage that link to word
documents. The user simply navigates the .htm pages with
IE 6.0 and clicks the link or document name to view. This
is working well -- however, we have an access database app
that we would like to handle in the same fashion, but we
are having problems.
have setup) we get a file download dialog box asking to
either open or save the file, choosing open gives a blank
page with nothing -- would like to aviod this dialog all
together and simply open the app in the same way IE opens
the word documents..

'viewer' like with word or excel or adobe pdf.

 

[Thomas A. Rowe]

Suggest you post to the Access newsgroup, or you will need to learn ASP/VBScript and recreate your
forms and reports, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Thanks for the reply. Our problem is that the Access mdb file is an app with

forms/queries/reports already setup. I doubt we could create the interface we want using the
frontpage database results wizard. After further research yesturday, it appears the problem is that
excel and word documents are treated somewhat native to frontpage and when selected to the user it
looks much like it does with windows explorer (document is opened). I can understand there will be
a different set of issues with a database, but was hoping there was some way in either frontpage or
through security settings, ect. in internet explorer to accomplish this -- The IE running on these
machines will not have internet access, so no need to worry about settings affecting web browsing
experiences.