||[Nov. 10th, 2006|11:43 am]
I swear MS Access is the worst piece of software ever written.
The stupid SQL view window won't accept perfectly good mysql syntax telling me I have a missing operator, so instead of doing "COUNT (DISTINCT field) FROM table", which takes less than a second to execute when you do it in mysql, you have to do "COUNT (*) FROM (SELECT DISTINCT field FROM table)", which, besides being really ugly, takes forever to execute.
Even worse, if you use the Design View when working with an Oracle database and look in the SQL view, it gives you SQL that uses JOIN statements that don't actually work in Oracle. How it executes these queries is beyond me, because it's using the same damn ODBC driver I am and claiming to use a syntax that it can't possibly be using. Is it too much to ask that software not actually lie to me about what it's doing?