Results 1 to 3 of 3

Thread: When to use SQL Server? vs MS Access

  1. #1

    Thread Starter
    Member otherones's Avatar
    Join Date
    Jun 2002
    Location
    Milk Factory
    Posts
    59

    When to use SQL Server? vs MS Access

    We are in the process of putting together a web server in which we will be using IIS and ASP.NET...

    Our site will have a lot of data, however we rarely get more than 2000 vistits/day... and normally between 20,000-60,0000 page accesses per day...

    How much can using oledb to query a ms access Jet db that is on the webserver machine handle...

    or reworded... will we need to run a SQL server... or are we safe querying .mdb files?

    any input would be welcome.
    CSC

  2. #2
    Lively Member
    Join Date
    Aug 2002
    Location
    outerspace
    Posts
    126
    If you can afford it I would say that using an enterprise db is definlty the way to go.
    "All those who wonder are not lost" -j.r.r tolkien

  3. #3
    Banished Cander's Avatar
    Join Date
    Dec 2000
    Location
    Why do you care?
    Posts
    6,913
    Access will NOT handle that much traffic. Most concurrent users an access can handle without any major performance problems is about 4 or 5..After than...*thhhhhbbppptttt*

    Stack Overflow
    See the features of Visual Studio 2010 and C# 4.0: The 10-4 show on Channel9

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width