Stephanie Giovannini (5/20/2008)
I am feeling very charitable toward SQL Server right now. It's a great product!Yesterday, I had to assist another developer in writing queries for MS Access, interpreting its useless error messages, figuring out that "statement must be updateable query" meant that it didn't allow any subqueries in an update statement, and, to top it all off, practicing the black magic of placing enough parentheses in the FROM clause so it wouldn't scream syntax error.
When you think about how bad it could be... SQL Server is a great product!
If you're down on MS Access, you should try a REAL "winner".... Say - Lotus Approach:) You'll be begging for the computing power, and ease of use of MSAccess in, oh - 2 hours (including the installation time)....
But I agree - I think SQL Server is very well put together all in all. Sure, there are some rather "interesting" choices that make us all jump through hoops, but that's what we have to do to earn our keep on a daily basis...
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?