Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smarta
Starting Member
3 Posts |
 Posted - 2010-10-23 : 19:24:51
|
| Hi everybody,I am writing to you to ask for a counsel:• I am using Microsoft Office 2003;• I developed an application, in Access, Dividing Data from Logic;• My intention is to put Data (I created one .mdb for each table) on the server and Logic (Forms, etc.) in each Workstation.My first question is as follow:• If I use Window Server, how many Workstations can be connected and work concurrently, without problems, on the same table (i.e.: inventory.mdb)?My second question is as follow:• If I use MS SQL Server (upgrading only data on the server), would be better in terms of concurrent number of Workstations?I know that are not easy questions to answer, but I do not need an exact number. It will be enough, for each one, an approximation (i.e.: 20, 50, 100, etc.).I would like if you will answer to both my questions.Thank a lot for your help and best regards. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
smarta
Starting Member
3 Posts |
Posted - 2010-10-23 : 19:59:15
|
| Thanks a lot for your quick answer.Lets suppose the following scenario:- One Windows Server or One MS SQL Server;- 200 workstations running Windows XP Professional;- 100 workstation concurrently connected and accessing the same table on the server;- additional 100 workstations connected and accessing other tables on the server.Can you give to me a rough idea about the hardware size for both, the server and the workstations?Considering results and price, will be better Windows Server or MS SQL Server? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
MS Access - MS SQL Server / Windows Server