Front Page - SQL Server 2000 with FrontPage

Author

SQL Server 2000 with FrontPage

Jason K

2004-03-30, 9:33 pm

Hi,

I'd like some opinions as to what path I should be looking into.

Here is my situation. I currently have Access databases that allow
data entry via a form. I'm planning on taking these databases and
moving them to SQL Server 2000. At the same time, I've been asked to
create a web page that will allow users to perform this data entry.
Manangement would like the ability to also view metrics based off the
data entry via the web as well. At first I thought SharePoint
Services would be the answer but it doesn't look like SPS can handle
the data entry; only good for viewing data

I read in the forums that FrontPage has a feature that allows you to
connect to a SQL database. I also read something along the lines of
Pivot Tables in Front Page. However, neither of these were explained
during the demo on microsoft.com Can I create a web page via FP and
have the data go into SQL Server? Can FP also create html that could
be used for a report, or is Pivot Tables better? I very fluent in PT.

I'm by no means a programmer, that's why I like Access and SQL Server
2000 as opposed to other languages that I would have to write.

I'm lost as to where I should start.

Thanks for any tips.

Kevin Spencer

2004-03-31, 9:29 am

FrontPage has tools that automate the writing of ASP and ASP.Net pages, that
can connect to most databases and work with the data. In addition, it
supports working with SharePoint Portal Server webs and WebParts. SPS is a
framework in which a programmer can create WebParts that do almost anything.
However, the WebParts that come pre-built with it do not allow data entry,
as you've noticed. FrontPage has wizqards which can help you create ASP and
ASP.Net pages that can fetch and display data, allow entry of new records,
and update or delete existing data. With a little extra programming, you can
do nearly anything you want with FrontPage and ASP or ASP.Net.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Jason K" <jasonkaplan@wideopenwest.com> wrote in message
news:2f9eb8a5.0403301357.45f03a5e@posting.google.com...
> Hi,
>
> I'd like some opinions as to what path I should be looking into.
>
> Here is my situation. I currently have Access databases that allow
> data entry via a form. I'm planning on taking these databases and
> moving them to SQL Server 2000. At the same time, I've been asked to
> create a web page that will allow users to perform this data entry.
> Manangement would like the ability to also view metrics based off the
> data entry via the web as well. At first I thought SharePoint
> Services would be the answer but it doesn't look like SPS can handle
> the data entry; only good for viewing data
>
> I read in the forums that FrontPage has a feature that allows you to
> connect to a SQL database. I also read something along the lines of
> Pivot Tables in Front Page. However, neither of these were explained
> during the demo on microsoft.com Can I create a web page via FP and
> have the data go into SQL Server? Can FP also create html that could
> be used for a report, or is Pivot Tables better? I very fluent in PT.
>
> I'm by no means a programmer, that's why I like Access and SQL Server
> 2000 as opposed to other languages that I would have to write.
>
> I'm lost as to where I should start.
>
> Thanks for any tips.

Jason

2004-03-31, 10:40 am

Thanks Kevin for the tips and the reply.

Jason

>-----Original Message-----
>FrontPage has tools that automate the writing of ASP and
ASP.Net pages, that
>can connect to most databases and work with the data. In
addition, it
>supports working with SharePoint Portal Server webs and
WebParts. SPS is a
>framework in which a programmer can create WebParts that
do almost anything.
>However, the WebParts that come pre-built with it do not
allow data entry,
>as you've noticed. FrontPage has wizqards which can help
you create ASP and
>ASP.Net pages that can fetch and display data, allow
entry of new records,
>and update or delete existing data. With a little extra
programming, you can
>do nearly anything you want with FrontPage and ASP or
ASP.Net.
>
>--
>HTH,
>Kevin Spencer
>..Net Developer
>Microsoft MVP
>Big things are made up
>of lots of little things.
>
>"Jason K" <jasonkaplan@wideopenwest.com> wrote in message
>news:2f9eb8a5.0403301357.45f03a5e@posting.google.com...
looking into.[color=darkred]
databases that allow[color=darkred]
databases and[color=darkred]
I've been asked to[color=darkred]
this data entry.[color=darkred]
metrics based off the[color=darkred]
SharePoint[color=darkred]
SPS can handle[color=darkred]
allows you to[color=darkred]
along the lines of[color=darkred]
were explained[color=darkred]
page via FP and[color=darkred]
html that could[color=darkred]
very fluent in PT.[color=darkred]
and SQL Server[color=darkred]
to write.[color=darkred]
>
>
>.
>