I'm a little disappointed you didn't discuss pass-through queries as well.  Users can use the more robust T-SQL and get results much faster.  Jet is inefficient comparatively.  The only drawback is that one must have mastery of syntax as there is no syntax checker.

Seth