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...