Access database and frontpage

I am new to using Frontpage and Access and would like some advice. I have
created an intranet site fro the school no problems, but I have also created
a database to keep track of the ICT rooms and their bookings. The data access
page I have incorporated into a front page page and it works well run locally
as it picks up the database from my machine, but when I publish it to the
server I get the form but not the information conatined within the database.
I get the message abou needing to install web componants, but I cannot find
them anywhere. Help please, before I go any greyer.

Kathleen
Wed Nov 10 22:11:13 CST 2004

Are you publishing to a Windows server that supports ASP and Access?

What is the exact text of the error message? What web components?


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/



dp5097 <dp5097@discussions.microsoft.com> wrote:
> I am new to using Frontpage and Access and would like some advice. I
> have created an intranet site fro the school no problems, but I have
> also created a database to keep track of the ICT rooms and their
> bookings. The data access page I have incorporated into a front page
> page and it works well run locally as it picks up the database from
> my machine, but when I publish it to the server I get the form but
> not the information conatined within the database. I get the message
> abou needing to install web componants, but I cannot find them
> anywhere. Help please, before I go any greyer.

CodeBubba
Sat Nov 27 19:56:43 CST 2004

In order to use Access (or SQL Server) from FrontPage, your database must be
referenced using what's called a DSN (Data-Set-Name). In both cases (your
local machine) and the server to which you publish a DSN must exist so your
ASP code (or DataResults Wizard) knows where to find your Access file.

I'm using FP2002 with Access2002 myself. Being a developer it didn't take
me long to figure out how to do this - however to someone not familiar with
databases there are a number of books on the subject. Pick up a copy of
"Microsoft Front Page 2002 Unleashed" at your local bookstore, you should
still be able to find a copy. (If you're using an earlier version of
FrontPage you might want to upgrade to 2002 (XP)). There are sufficient
details in the book to help you get up to speed on this. Making a database
work with FrontPage takes a little bit of work but is not that hard once you
get the routine.

HTH,

-bruce

"dp5097" <dp5097@discussions.microsoft.com> wrote in message
news:2A1F383B-187B-44E1-B856-5292ED6A0184@microsoft.com...
>I am new to using Frontpage and Access and would like some advice. I have
> created an intranet site fro the school no problems, but I have also
> created
> a database to keep track of the ICT rooms and their bookings. The data
> access
> page I have incorporated into a front page page and it works well run
> locally
> as it picks up the database from my machine, but when I publish it to the
> server I get the form but not the information conatined within the
> database.
> I get the message abou needing to install web componants, but I cannot
> find
> them anywhere. Help please, before I go any greyer.
>

Kevin
Mon Nov 29 07:47:14 CST 2004

> In order to use Access (or SQL Server) from FrontPage, your database must
be
> referenced using what's called a DSN (Data-Set-Name).

1. The basic content of the statement is not true. A DSN is not necessary to
connect to a database. It is one of several ways to connect. The best way to
connect is through OLE DB (Object Linking and Embedding for Databases),
which ODBC (A DSN is a connector for ODBC - Open Database Connectivity) is
a wrapper for. Actually, if using ASP.Net, and if using SQL Server, the
native .Net SQL Provider is faster than OLE DB.

2. "DSN" is an acronym for "Data Source Name."

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"CodeBubba" <broeser@cfl.rr.com> wrote in message
news:eRL6E2O1EHA.2824@TK2MSFTNGP09.phx.gbl...
> In order to use Access (or SQL Server) from FrontPage, your database must
be
> referenced using what's called a DSN (Data-Set-Name). In both cases (your
> local machine) and the server to which you publish a DSN must exist so
your
> ASP code (or DataResults Wizard) knows where to find your Access file.
>
> I'm using FP2002 with Access2002 myself. Being a developer it didn't take
> me long to figure out how to do this - however to someone not familiar
with
> databases there are a number of books on the subject. Pick up a copy of
> "Microsoft Front Page 2002 Unleashed" at your local bookstore, you should
> still be able to find a copy. (If you're using an earlier version of
> FrontPage you might want to upgrade to 2002 (XP)). There are sufficient
> details in the book to help you get up to speed on this. Making a
database
> work with FrontPage takes a little bit of work but is not that hard once
you
> get the routine.
>
> HTH,
>
> -bruce
>
> "dp5097" <dp5097@discussions.microsoft.com> wrote in message
> news:2A1F383B-187B-44E1-B856-5292ED6A0184@microsoft.com...
> >I am new to using Frontpage and Access and would like some advice. I have
> > created an intranet site fro the school no problems, but I have also
> > created
> > a database to keep track of the ICT rooms and their bookings. The data
> > access
> > page I have incorporated into a front page page and it works well run
> > locally
> > as it picks up the database from my machine, but when I publish it to
the
> > server I get the form but not the information conatined within the
> > database.
> > I get the message abou needing to install web componants, but I cannot
> > find
> > them anywhere. Help please, before I go any greyer.
> >
>
>