Jeff Smith Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server

What I learned about SQL from using Access

Wed Jun 13, 2007 by Jeff Smith in miscellaneous, techniques, ms-access

Let's open up the mailbag! In today's exciting episode, Nemo writes: Hi, I am doing a project that my boss "requires" to be done in Access, even though we have MS SQL server 2005! Read more →

Convert Microsoft Access (JET SQL) to SQL Server (T-SQL) Cheatsheet

Fri Mar 30, 2007 by Jeff Smith in t-sql, ms-access

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 few handy things to help you out with converting your projects. Read more →

Discussing VB and/or MS Access in a Programming Forum

Tue Jun 6, 2006 by Jeff Smith in ms-access, humor

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 →