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