Text files vs. Access vs. SQL Server vs. Others

<i><b>Originally posted by : Steven (avrahim@hotmail.com)</b></i><br />To All:<br /><br />I was wondering at what point should you move from using text files to hold data on up to Access. And even from Access to SQL Server. I guess what I'm asking is what is the user amount level that each can maintain comfortably. Thanks.

<i><b>Originally posted by : steve</b></i><br />this is more a basic architecture question on a project. I've never know anyone to store there data in a text file. No security. http://url/data.txt file and all your data is shown to the world<br /><br />Access, its a nice department or test back in database. maybe 10 - 15 users concurrently. I wouldn't do add, update, deletes of data with a lot of users concurrently.<br /><br />SQL, well this is my choice, downside that it is costly, and requires some knowledge to install, maintain the server and databases. But if your doing anykind of money making venture this is definately a preferred method. <br /><br />hope this helps. <br /><br /><br />------------<br />Steven at 5/18/2000 4:52:27 AM<br /><br />To All:<br /><br />I was wondering at what point should you move from using text files to hold data on up to Access. And even from Access to SQL Server. I guess what I'm asking is what is the user amount level that each can maintain comfortably. Thanks.