I've just started using MS Access 2007 heavily the past few days (after not having touched it since 2000). My issue is that I have written a query in SQL view that takes about 60 seconds to return ...

I'm plugging through learning how to use ODBC calls in PHP, and I think I'm missing some MS naming convention for calling queries via ODBC. where Query1 is a valid table name in MS Access, I get the ...