Software

Ask something
Discussion Locked

Will Access and ASP work for me?

0 helpful
1 reply

by bmiddleton

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am about to start to redesign our company's
website. We want to make it dynamic and pull
content and images from a database. Trying
to keep costs down, I am looking at using
Access for the database with ASP. Does this
sound like a good idea? We would also like to
build a searchable catalog, in the future.
Would Access work for this? Is it the best way
to go.

I am very new to this dynamic stuff and would
appreciate any comments.

I develop on a Mac and would have to use a
PC for the Access.

1 reply

by glen_mcleod

A web site usually has lots of connections at the same time, which means lots of connections to the database, which Access isn't good at. It was originally conceived as a desktop DB with minimal concurrency. Is still suffers from those limitations. I've seen well designed systems handle 15 connections at the same time, but the normal is 4-5 connections before serious performance issues appear and 8-10 connections before you start getting corruption.

Access's slightly bigger brother, MSDE,can handle more connections, and is a lot more intelligent, but for something like a web site you want to go to a full DBMS like SQL Server, Oracle, DB2, etc.

Glen

This discussion is closed to new replies.