I imagine SQL Server is better for enterprise apps as I've heard that Access doesn't scale that well. To be honest, small scale DBMS like MySQL and Firebird SQL have been sufficient for my uni/personal DB meanderings although I did do some DB unit-testing last year for a company that uses SQL Server.
I think there's a bit of developer elitism towards Access which is foolish as it's perfectly suitable for many situations.
|