SQL Server 2000 with FrontPage

[Jason K]

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]

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]

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.




.