What's faster than ODBC to query SQL data using Access?

[drhea]

I'd like to continue using a GUI to construct queries, as mine are always ad
hoc and unique (stored queries don't help me). ODBC is proving to be too
slow, and the volume of querying I must do makes GUI an efficient option.
I'm using Access from Office XP.
If there's nothing faster than ODBC within Access, is there another GUI I
can use to query SQL Server data?

 

[Van T. Dinh]

Pass-through Queries?

Check Access Help topic "Create an SQL-specific query".