I access data from an Oracle Datawarehouse for 90% of my reporting functions.

Currently I utilize ODBC in Access '97 to do this, with as much Pass-Through as possible.

I'm looking at changing this setup for speed considerations (and pretty resume building stuff

I'm looking to do one of two things:
Use ADO in VB to do everything.


Continue using Access as a backend, storing the queries/forms/reports etc. using VB as a front end.


Are there any particular benefits to one over the other? Which would give me the strongest performance boost?