MS Access
Yep ... MS Access. It's great. When used correctly, it is one of the handiest things you can use to complement your SQL development.
Microsoft Access / JET SQL doesn't support cursors; the only way to process rows one by one is using VBA and opening a Recordset. This means that you're stuck using set-based "queries". So ... is this a good thing or a bad thing? A very, very good thing -- in fact, it's what makes Access a great tool for learning SQL! read more...
Lots of questions come up in the SQL Team forums about conversions between Access and T-SQL and some of the differences between the two SQL dialects. Here's a nice list of handy things to help you out with converting your projects.
read more...
So, you've decide to write a comment about how bad either VB and/or MS Access is in a programming forum! Well, you've come to the right place, I'm here to help.
read more...