Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Limitations of Access


Message #1 by spencer saunders <ssaunders@i...> on Fri, 15 Mar 2002 14:21:49 -0500
Hello all, 


I am looking at a project that will start with a database of 800,000
records. This database will have approx. 400,000 users a month. Now I am
assuming that this is WAY out of access' league but will SQL Server 7.0 be
able to handle something like this? What's the highest number of users a SQL
Server can handle?

spencer

Message #2 by "Ken Schaefer" <ken@a...> on Sun, 17 Mar 2002 17:13:04 +1100
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "spencer saunders" <ssaunders@i...>
Subject: [access_asp] Limitations of Access


: I am looking at a project that will start with a database of 800,000
: records. This database will have approx. 400,000 users a month. Now I am
: assuming that this is WAY out of access' league but will SQL Server 7.0 be
: able to handle something like this? What's the highest number of users a
SQL
: Server can handle?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Depends on your hardware.

Take a look at www.tpc.org if you want to see want can be done if you have
an unlimited hardware budget.

Cheers
Ken


  Return to Index