Entry

When should I switch to SQL Server?

May 19th, 2000 06:59
unknown unknown, Joe Riley, Kevin D

SQL is more robust, can handle alot more querying, and updating, and 
server transactions at once.   SQL also has alot more security features, 
then MS Access.  

Access is basically what it was designed for, a desktop database.  
Access has it advantages, like cost for example.

The best time to switch is if you database is getting hit hard alot, and 
there is a need for something better.

SQL server is also better for larger databases. For example, access has 
a 1GB file size limit. SQL server has no such limit, amd in fact is much
faster than access with larger amounts of stored data.