Database results on FrontPage

S

Sophia

I have an Access database from which I want to display information on a
FrontPage website. Can I use an Access query to take information from various
tables and put the results on a webpage? I tried to copy an Access query in
SQL view to the Database results and create a query, but it did not work.

Is it possible to view an Access report on FrontPage, or an Access form on
FrontPage? Or are you only able to retrieve data from an Access table to put
on the website?

Also, if there is an Access front end and back end, can you only use the
back end to retrieve data to display on the website.

Finally, can the data be shown in a format other than a table?


Thank you for any help,
Sophia
 
R

Ronx

See comments inline below

--
Ron Symonds - Microsoft MVP (Expression)
Reply only to group - emails will be deleted unread.
http://www.rxs-enterprises.org/fp

Sophia said:
I have an Access database from which I want to display information on a
FrontPage website. Can I use an Access query to take information from
various
tables and put the results on a webpage? I tried to copy an Access query
in
SQL view to the Database results and create a query, but it did not work.


What errors? Some Access queries need slight adaption to work on the web,
but generally SQL copied from Access into the database results wizard will
work correctly.
If you supply the query in a reply to this post we can check it for you.

Is it possible to view an Access report on FrontPage, or an Access form
on
FrontPage? Or are you only able to retrieve data from an Access table to
put
on the website?


You can only use web pages to display or collect data.

Also, if there is an Access front end and back end, can you only use the
back end to retrieve data to display on the website.


Back end - in particular, the database in the web site. The website does
not run Access - it runs the "engine" that supports Access.

Finally, can the data be shown in a format other than a table?


The display of data is up to the web page developer. Often a table is the
best way, but that does not exclude the use of freeform, but you will have
to write the code and markup yourself.

The page at http://www.rxs-enterprises.co.uk/fp/?fl=1101651334 takes data
from several tables and displays some of this in a table, and some
freeform. Everything inside the yellow border (including the left menu)
comes from the database except the search form.
This is a .aspx page, but the original used .asp and access.

The database wizards in FrontPage provide at least 2 methods of displaying
data - a table for multiple records with fields in columns, and individual
records with each field on its own line.
 
S

Sophia

Thank you Ronx for the information!

As a test, I used only three fields from my database to view the results.
Then I did the same as a query in Access. I then used the SQL view and
copied it to the "custom" database option in Frontpage. So, I do have the
differences. I'll look it over again and ask if I have a problem.
 
K

Kathleen Anderson

S

Sophia

Kathleen: I don't understand. Also, what is a DBRW? Do you mean to go to
"Insert" ,"Database", "Data View"? If so, I get an error message that it can
only be used on servers running SharePoint Services and I can't do anything
else.

Sophia
 
K

Kathleen Anderson

S

Sophia

Kathleen: I don't seem to have those options. When I (Insert > Database >
Results), the next options are (record source or custom query). Is that what
you are referring to? Do you mean to copy the query into the custom query
box?
 
K

Kathleen Anderson

S

Sophia

I am using the back end of the database, so the queries are in the front end.
Will I have to copy the query to the back end, or should I use the front end
as my database connection?
Sophia
 
S

Stefan B Rusynko

Any DB used in a site does not support front ends or back ends
- the DB needs to be complete w/ all tables and queries

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I don't have any experience with databases that have front ends and back
| ends, so I can't help you with this one. Hopefully someone else can.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| Expression Web Wiki: http://expression-web-wiki.com/
| FrontPage Resources: http://www.spiderwebwoman.com/resources/
| Please reply to the newsgroup for the benefit of others
|
|
|
| | >I am using the back end of the database, so the queries are in the front
| >end.
| > Will I have to copy the query to the back end, or should I use the front
| > end
| > as my database connection?
| > Sophia
| >
| > "Kathleen Anderson" wrote:
| >
| >> No. If the database in your web site has Access Queries in it, when you
| >> use
| >> the dropdown menu under Record source, your should see the queries listed
| >> with (View) after it.
| >>
| >> --
| >>
| >> ~ Kathleen Anderson
| >> Microsoft MVP - FrontPage
| >> Spider Web Woman Designs
| >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| >> Expression Web Wiki: http://expression-web-wiki.com/
| >> FrontPage Resources: http://www.spiderwebwoman.com/resources/
| >> Please reply to the newsgroup for the benefit of others
| >>
| >>
| >>
| >> | >> > Kathleen: I don't seem to have those options. When I (Insert >
| >> > Database
| >> > >
| >> > Results), the next options are (record source or custom query). Is
| >> > that
| >> > what
| >> > you are referring to? Do you mean to copy the query into the custom
| >> > query
| >> > box?
| >> >
| >> > "Kathleen Anderson" wrote:
| >> >
| >> >> DBRW = DataBase Results Wizard
| >> >>
| >> >> Start the wizard the way you normally do (Insert > Database >
| >> >> Results),
| >> >> but
| >> >> when you select your data source, select "View" instead of "Table".
| >> >>
| >> >> --
| >> >>
| >> >> ~ Kathleen Anderson
| >> >> Microsoft MVP - FrontPage
| >> >> Spider Web Woman Designs
| >> >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| >> >> Expression Web Wiki: http://expression-web-wiki.com/
| >> >> FrontPage Resources: http://www.spiderwebwoman.com/resources/
| >> >> Please reply to the newsgroup for the benefit of others
| >> >>
| >> >>
| >> >>
| >> >> | >> >> > Kathleen: I don't understand. Also, what is a DBRW? Do you mean
| >> >> > to
| >> >> > go
| >> >> > to
| >> >> > "Insert" ,"Database", "Data View"? If so, I get an error message
| >> >> > that
| >> >> > it
| >> >> > can
| >> >> > only be used on servers running SharePoint Services and I can't do
| >> >> > anything
| >> >> > else.
| >> >> >
| >> >> > Sophia
| >> >> >
| >> >> > "Kathleen Anderson" wrote:
| >> >> >
| >> >> >> Sophia:
| >> >> >> Another way to do this is to save the SQL in the Access database as
| >> >> >> an
| >> >> >> Access Query, and then use it in the DBRW - you would select "View"
| >> >> >> as
| >> >> >> your
| >> >> >> datasource instead of Table.
| >> >> >>
| >> >> >> --
| >> >> >>
| >> >> >> ~ Kathleen Anderson
| >> >> >> Microsoft MVP - FrontPage
| >> >> >> Spider Web Woman Designs
| >> >> >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| >> >> >> Expression Web Wiki: http://expression-web-wiki.com/
| >> >> >> FrontPage Resources: http://www.spiderwebwoman.com/resources/
| >> >> >> Please reply to the newsgroup for the benefit of others
| >> >> >>
| >> >> >>
| >> >> >>
| >> >> >> | >> >> >> > Thank you Ronx for the information!
| >> >> >> >
| >> >> >> > As a test, I used only three fields from my database to view the
| >> >> >> > results.
| >> >> >> > Then I did the same as a query in Access. I then used the SQL
| >> >> >> > view
| >> >> >> > and
| >> >> >> > copied it to the "custom" database option in Frontpage. So, I do
| >> >> >> > have
| >> >> >> > the
| >> >> >> > differences. I'll look it over again and ask if I have a
| >> >> >> > problem.
| >> >> >> >
| >> >> >> >
| >> >> >> >
| >> >> >> >
| >> >> >> > "Ronx" wrote:
| >> >> >> >
| >> >> >> >> See comments inline below
| >> >> >> >>
| >> >> >> >> --
| >> >> >> >> Ron Symonds - Microsoft MVP (Expression)
| >> >> >> >> Reply only to group - emails will be deleted unread.
| >> >> >> >> http://www.rxs-enterprises.org/fp
| >> >> >> >>
| >> >> >> >> | >> >> >> >> > I have an Access database from which I want to display
| >> >> >> >> > information
| >> >> >> >> > on a
| >> >> >> >> > FrontPage website. Can I use an Access query to take
| >> >> >> >> > information
| >> >> >> >> > from
| >> >> >> >> > various
| >> >> >> >> > tables and put the results on a webpage? I tried to copy an
| >> >> >> >> > Access
| >> >> >> >> > query
| >> >> >> >> > in
| >> >> >> >> > SQL view to the Database results and create a query, but it
| >> >> >> >> > did
| >> >> >> >> > not
| >> >> >> >> > work.
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> What errors? Some Access queries need slight adaption to work
| >> >> >> >> on
| >> >> >> >> the
| >> >> >> >> web,
| >> >> >> >> but generally SQL copied from Access into the database results
| >> >> >> >> wizard
| >> >> >> >> will
| >> >> >> >> work correctly.
| >> >> >> >> If you supply the query in a reply to this post we can check it
| >> >> >> >> for
| >> >> >> >> you.
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> >
| >> >> >> >> > Is it possible to view an Access report on FrontPage, or an
| >> >> >> >> > Access
| >> >> >> >> > form
| >> >> >> >> > on
| >> >> >> >> > FrontPage? Or are you only able to retrieve data from an
| >> >> >> >> > Access
| >> >> >> >> > table
| >> >> >> >> > to
| >> >> >> >> > put
| >> >> >> >> > on the website?
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> You can only use web pages to display or collect data.
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> >
| >> >> >> >> > Also, if there is an Access front end and back end, can you
| >> >> >> >> > only
| >> >> >> >> > use
| >> >> >> >> > the
| >> >> >> >> > back end to retrieve data to display on the website.
| >> >> >> >> >
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> Back end - in particular, the database in the web site. The
| >> >> >> >> website
| >> >> >> >> does
| >> >> >> >> not run Access - it runs the "engine" that supports Access.
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> > Finally, can the data be shown in a format other than a table?
| >> >> >> >> >
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> The display of data is up to the web page developer. Often a
| >> >> >> >> table
| >> >> >> >> is
| >> >> >> >> the
| >> >> >> >> best way, but that does not exclude the use of freeform, but you
| >> >> >> >> will
| >> >> >> >> have
| >> >> >> >> to write the code and markup yourself.
| >> >> >> >>
| >> >> >> >> The page at http://www.rxs-enterprises.co.uk/fp/?fl=1101651334
| >> >> >> >> takes
| >> >> >> >> data
| >> >> >> >> from several tables and displays some of this in a table, and
| >> >> >> >> some
| >> >> >> >> freeform. Everything inside the yellow border (including the
| >> >> >> >> left
| >> >> >> >> menu)
| >> >> >> >> comes from the database except the search form.
| >> >> >> >> This is a .aspx page, but the original used .asp and access.
| >> >> >> >>
| >> >> >> >> The database wizards in FrontPage provide at least 2 methods of
| >> >> >> >> displaying
| >> >> >> >> data - a table for multiple records with fields in columns, and
| >> >> >> >> individual
| >> >> >> >> records with each field on its own line.
| >> >> >> >>
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> >
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> > Thank you for any help,
| >> >> >> >> > Sophia
| >> >> >> >> >
| >> >> >> >> >
| >> >> >> >>
| >> >> >> >>
| >> >> >>
| >> >> >>
| >> >> >>
| >> >>
| >> >>
| >> >>
| >>
| >>
| >>
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top