Front Page - Linking Frontpage document to Access database?

Author

Linking Frontpage document to Access database?

Net55

2004-04-30, 4:30 am

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
net55@frontpagewiz.com
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..
>
>Ideas?
>.
>

Darin Grimm

2004-04-30, 9:29 am

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 th
e 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 datab
ase, 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 brows
ing experiences.

Darin

----- 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.

Net55
net55@frontpagewiz.com
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.
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..[color=darkred]
>.
>

Andrew Murray

2004-04-30, 9:29 am

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

See these examples:

ht|p://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?

"Darin Grimm" <dgrimm@msn.com> wrote in message
news:DD2473A5-8790-4F02-BD50-8302E7C86F8E@microsoft.com...
>
> 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.[color=darkred]
>
> Darin
>
>
> ----- 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.
>
> Net55
> net55@frontpagewiz.com
> 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..

Andrew Murray

2004-04-30, 9:29 am

"Net55" <net55@frontpagewiz.com> wrote in message
news:64b301c42e6d$987dc9f0$a501280a@phx.gbl...[color=darkred]
> 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
> net55@frontpagewiz.com
> 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

2004-04-30, 5:34 pm

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Darin Grimm" <dgrimm@msn.com> wrote in message
news:DD2473A5-8790-4F02-BD50-8302E7C86F8E@microsoft.com...
>
> 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.[color=darkred]
>
> Darin
>
>
> ----- 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.
>
> Net55
> net55@frontpagewiz.com
> 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..