what to use for front end and database

[Guest]

Hi,

I am currently using Frontpage along with access to create the website. As
more customers access the site, it is becoming very slow. I know access in a
real world can support between 25 - 50 users simultaneouly.

We are planning to upgrade our database, so it can support more users
without compromising the speed. I am using frontpage 2002, which has lot of
limitations.

Any suggestions on what program to use for front end, and what database to
use.

Any help will be greatly appreciated.

Thanks,

Shikha

 

[David Berry]

If you're expecting more users then you should see if your ISP offers SQL
Server space. You can still use FrontPage for the front-end.

 

[Guest]

Hi David,

I called the webhosting and they do support sql server space. So all i
would need is to get the sql, and should be good to go...right?

sorry never dealt much with sql...

Thanks once again!

 

[David Berry]

Yes. You can use the Database Wizard to connect to the SQL Server database
and any pages you already have will keep working. You may want to get a
book on SQL though. There are other things you can do to speed up your
site, such as creating Stored Procedures to do task like updating, inserting
etc and then just call the stored procedure in your page.

 

[Guest]

Hey David,

Thank you for such a quick reply! I reallly appreicate it, I will
definitely get a book on SQL, and order SQL Server as well.

once again David, you are the best!