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 |
|
psychosis
Starting Member
2 Posts |
 Posted - 2008-12-11 : 16:40:01
|
| Hi everyone, I'm pretty much a newbie to SQL server (I just installed it at work! :) )I have a few questions, just to get me going in the right direction. First I'll give the context...I just started working as an IT technician in an office/warehouse environment that has about 10 people... We've made an Access 2007 database for inventory and invoice purposes, and would like to have the database served to the various employees in the office and warehouse with different views and such. It seems that spreadsheets become a problem for everyone because there are countless files to deal with.People will be working on the database at the same time, so I'm assuming that an SQL server (or Sharepoint?) has to be installed to prevent any deadlock, implementing views, and other security reasons. Regardless, I'd like to get some experience with maintaining an SQL server. We have MS SQL server 2008 at work.Anyway, as of now we have a peer-to-peer network setup. Is operating an SQL server on a p2p network of this size a practical setup? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
psychosis
Starting Member
2 Posts |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-12 : 06:04:23
|
| You could use MSAccess, 10 users is the recommended maximum number of concurrent users but more is possible.But if you have SQL Server 2008 obviously this will give you greater facilities. There are also other options such as SQL Server Express. You could set-up a web front-end for either Access or SQL Server.You could even setup macros in Excel to save to Access database.It really depends on how sophisticated this needs to be, how many users, how big will this grow etc. |
 |
|
|
|
|
|
Is this appropriate for a small office?