June 5, 2003
I'm working on a small project, cleaning up someone else's scripts and database. It's using PHP and Access. (Yes, PHP can use Windows ODBC. It just sucks a lot.) I'm using SQL that's been standard since 1988, and Access is choking all over it and giving an unintelligible error.
God, I hate Access.
Update: Finally got it figured out; there's a type of INSERT statement that Access just can't do. Breaking it into many little statements works fine, although it creats more server overhead. Ah well. It's humming along fine now; in fact the people who couldn't register yesterday have all registered today!
Jason 1, Shitty MS DB App 0
