JohnAtWork
Feb 17th, 2000, 05:01 AM
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?
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?