Mischamel Posted August 26, 2004 Posted August 26, 2004 Hi, I´m about to create a WebFrontEnd, which has to be connected to aDatabase, which receives its Data from a SystemDatabase. My question is the following: How many users can work with an Access Db synchronous. The Frontend is going to be written in ASP.NET and will be running on IIS. The Access DB will be on the same machine as the WebApplication will be. I could also copy the origin Data into MSSQL-Server instead of AccessDB. But I´ve got no experience with MSSql. Does MSSQL-Server still require IIS or is the MSSQL-Server a single as a server-working Database ?? There wouldn´t be more than 50 users be working synchronous. Thanks in advance Quote Sometimes you´ve got to make a silent Takedown .
samsmithnz Posted August 26, 2004 Posted August 26, 2004 I would say that if you're building it for up to 50 people use SQL. Access is really only ok if you have a couple people, half a dozen at most. Quote Thanks Sam http://www.samsmith.co.nz
*Gurus* Derek Stone Posted August 26, 2004 *Gurus* Posted August 26, 2004 You shouldn't even be considering Microsoft Access. It doesn't scale, and it's not reliable. Quote Posting Guidelines
Arch4ngel Posted August 26, 2004 Posted August 26, 2004 I agree with Derek. If you can do it in SQL-Server then... do it. I use Access DB only for small Access App that need "Report" or for some small company that need a "tool" to keep user data and that can't afford to buy a server or to upgrade their old P2 500Mhz. So they have DB and the App and there are only 1 user on it. Beside that... I rather use Sql-Server. Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
Mischamel Posted September 1, 2004 Author Posted September 1, 2004 Thank you so far for your excellent advices. Does anyone of you know a link to helpful documentation, of how to setup a mssql server and how to use it ?? Quote Sometimes you´ve got to make a silent Takedown .
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.