|
|
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 100'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 simultaneous users.
We always recommend SQL Server, and include a free runtime
version in our 'Basic Install plus MSDE' package .
It supports any number of users, but performance begins to degrade with more
than 8 simultaneous users. It's a great way to start out, and you
can always upgrade to a full SQL Server license later.
|
|