Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Access or other DBs?

Discussion in 'Information Technology' started by abcd, Nov 3, 2005.

Tags:
  1. abcd

    abcd
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "abcd" <abcd@abcd.com> wrote:

    >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. ?


    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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page