linking to update

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

How may I link my site to ONE page in Access or a similar
program to have it automatically update on my site when I
make changes?
 
Requires that you create a custom ASP based application (add, edit, delete
and login access) to store the data, and when the page is loaded, will
automatically query the database for it's content.

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
How would I create a custom ASP based application?
-----Original Message-----
Requires that you create a custom ASP based application (add, edit, delete
and login access) to store the data, and when the page is loaded, will
automatically query the database for it's content.

--

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

FrontPage Resources, Forums, 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




.
Click to expand...
 
You have to learn ASP. A good start point is http://www.asp101.com
(samples).

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Hi Amanda,

Maybe I am not understanding your issue. It sounds like you want a page
that will display dynamic content that will be pulled from an Access data
base. Is this correct?

If so, you can do this really easily in FrontPage 2002 or 2003.

Use the Web Templates to create a new Database Interface Wizard and follow
the steps to create a new site. Doing so will create the application for
you and will create several pages for updating, adding and deleting data
from the database.

Then you can also use this database inside any pages on your site by
clicking on Insert > Database Results.

Based on Thomas's answer, maybe I am misunderstanding what you want to do,
so can you clarify or post an example URL that you are thinking of?

-John Jansen
Microsoft
 
Yes, you could link to a Word document, but besides the fact that all user
would need to have Word or the Word Viewer, the document would have to
always be named the same, and be upload to the same location, etc.

--

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

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

In order for Amanda do what she originally asked, she would need to create a
back-end ASP database application that would allow controlled access to
entering and editing content that would then be dynamically displayed on one
or more pages within her web site.

Most of this can be done using the FP database component, however you can
quickly run into limitation using it, so I tend to recommend that you learn
how to hand code ASP.

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Hi Thomas,

I agree that there are some limitations, but I would argue most are easily
worked around without needing to learn a lot of ASP.

However, regardless of the more complex issues, for someone who just wants
to get up and running and has FrontPage and has never created an Access
database, nor coded HTML or ASP and doesn't have any inclination or the time
to learn them, I think you'd be hard-pressed to find anything easier than
just creating a new sub site in FrontPage on an extended server. I mean,
you have to admit (and this is one of the reasons I work here, actually -
long story on that, though) that the Database Interface Wizard creates
everything you _need_ in a dead-simple format.

FrontPage even generates the authentication pages to perform the database
edits for you using server side authentication.

-John Jansen
 
John,

I agree that if a user has have very simple needs, such as display data from
a database, then the FP database component is a great solution, however to
extend the code generated by the FP database component, is not always an
easy task.

Unless the user is using FP2003, many of the basic functions need to build a
complete content type management application is not available in FP2000 or
FP2002 using the database component.

--

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

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Back
Top