Website and Database methodology question

[Jon Lewis]

Hi

I'm building a company Website using Frontpage 2003 but no very little about
web development. The site will be hosted by our ISP. At our office we run
Microsoft Small Business Server 2003 Premium which includes SQL Server.

We want the website to have some content which is restricted to registered
users so need a log on procedure and also eventually want to develop on-line
ordering for our customers.

My question is concerning whether the user/password data and the more
extensive customer/item/price data (Excel/Access MDB/SQL Server Database
info or whatever) would normally reside on the ISP's server with the Website
or is it normal to link the website to data stored somewhere else e.g. On
our office SBS Server.

Is there a norm for this ?

If the Data needs to reside with the website, how would it be maintained?

Many thanks

 

[Rob Giordano \(Crash\)]

On the online server - and it won't be Excel.

 

[Jon Lewis]

Well our local SBS 2003 Server is accessible online but I assume you mean
the ISP server that hosts our website?

If so what would be the normal way to synchronise database info between our
local db's and the info we need available to the website?

Many thanks

 

[Thomas A. Rowe]

If you are using MS SQL Server and it is connected to the internet, then yes, you could allow the
web site to have access. I suggest you speak with your ISP and System Admin to make sure it is
secure.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================