Access or other DBs?

A

abcd

My web applicaiton will be used by intranet users say 10-500 and may be
more. Currently I have prototyped my Web application using MS Access. Can
somebody justify me that Access is not the right DB for such
load/connections. What are the disadvantages of using Access in such
situation. What other databases will be the best match. like SQL Server
Express, Sybase Adaptive Anywhere. ?

It will be nice if I get the comparision list somewhere...

Thanks
 
A

aaron.kempf

it would be crazy to use MDB for anything in the real world.

you shoudl use MSSQL for that many connections.

if you do you connection sharing correctly; you could probably get by
with MSDE

i personally think that there are only 2 databases that are at all
competitive-- MS SQL Server and mySql.

-aaron
 
K

Kevin.S.Campbell

I mean there are several things to take into consideration. First,
price, how much money do you have to play around with? If you have
zero to a limited amount of money, I would consider MySQL. MySQl 5.0
jut came out and it is quite excellent product, plus it's free =).
Might consider that. If not SQL Server and Oracle are wonderful
products, just bring the money haha. Second, what type of platform are
you doing, internet, application based(intranet)? If your delievering
a web application you have choices of ASP/ASP.net, Java/JSP, and PHP.
I'll leave that to you decide to what language to consider. Third, how
important is this? I mean, if this is finiancial database or
mission-critical data, consider good hardware investment. Lastly, you
mentioned users, 10-500, Access would crash and die with this many
users. Access I have seen under heavy load support about 5 users
inserting data, and 5-10 user running searches and reports at one time.
Even this was not problems (concurrency, crashes, etc). If i were
you...think about these factors then decide. Good luck.
 
A

aaron.kempf

sql server has a free version called MSDE and a much better free
version called SQL Server 2005 Express.

I definitely agree; i wouldn't use MDB in the real world for anything.

NEVER ONCE ANYWHERE.

-Aaron
 
T

Tony Toews

abcd said:
My web applicaiton will be used by intranet users say 10-500 and may be
more. Currently I have prototyped my Web application using MS Access. Can
somebody justify me that Access is not the right DB for such
load/connections. What are the disadvantages of using Access in such
situation. What other databases will be the best match. like SQL Server
Express, Sybase Adaptive Anywhere. ?
Click to expand...

No specific page that I know of however ten users would likely be fine
on an Access app. But 500 certainly wouldn't be. Where is the middle
ground? No idea.

Clearly if you are using IIS and such then SQL Server Express would be
a better match. But as to what problems you could have with other
products I don't know. Oracle just came out with a free for personal
use version IIRC the details correctly. So you could even use that
one for testing purposes.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top