I am using Access 2000 right now but I am curious as to how large my database can be before it becomes unreliable. When do I need to consider using MS SQL 2000? Is there a maximum number of members I should allow with an Access database or are there other factors to consider such as PC hardware etc.?
If its within the budget, moving to SQL Server or MySql is always a good idea as it will save you the trouble of finding yourself up the creek later.
The biggest problem with Access is the number of connections it can handle. If you are getting a high volum of traffic (all at the same time) you should upgrade. You can have a site with 500 memebers... as long as they all aren't trying to hit the site at the same time.
Does this help? (oh, more memory/better hardware always helps!)
Topic Locked
Posted - 06 November 2005 : 19:07:08
