SQL Server vs. Access
Microsoft SQL Server is a database server. There is a SQL Server program
that manages all client requests to read and write data. It can scale to
1000's of users, and will provide better performance than Access with just
a few simultaneous users.
Microsoft Access is a file based database. IssueView clients are really just reading and writting to a file, via Microsoft's OLEDB interface. It's perfect for solo users, and can adequately support up to around 10 occasional users.
We always recommend SQL Server, and include a free runtime version in our 'Basic Install plus SQL Express' package . It supports any number of users, but only runs on 1 CPU, and limits the database size to 4 GB. It's a great way to start out, and you can always upgrade to a full SQL Server license later.
Microsoft Access is a file based database. IssueView clients are really just reading and writting to a file, via Microsoft's OLEDB interface. It's perfect for solo users, and can adequately support up to around 10 occasional users.
We always recommend SQL Server, and include a free runtime version in our 'Basic Install plus SQL Express' package . It supports any number of users, but only runs on 1 CPU, and limits the database size to 4 GB. It's a great way to start out, and you can always upgrade to a full SQL Server license later.
