Use 1 or more Databases
Posted on 2003-03-25
I am in the process of creating a large website. Should I have a different database for each of my systems? For example, I have 400 clients now, would like this number to increase, and each of them will have access to atleast one of my systems. And within that system for that client they might have up to 10 users(maybe even more). I currently have 5 different systems that I am working on incorporating into my website. I currently have 1 database with my account and user and system information. I now want to start working on one of these systems. I have many different functions that my user will be able to perform and therefore this will get quite large. Should I create a new database for all of this information? I am currently using Microsoft Access, should I switch to SQL Server?