SQL and VBA performance gains

[Mark Reed MCSE]

I have a large database 220mb (well I think it's large), I run some heavy
SQL and VBA in modules to extract data as I require. These are repetitive
tasks and I've improved performance on my own by experimenting with a
mixture of SQL and VBA. If a use SQL to narrow down the records and then use
VBA to move through the record set to find the data I'm after, this seems to
be the fastest way (MUCH FASTER) - at the moment.

There's no need for precise code on this as I'm teaching myself at the
moment and I'd prefer to experiment and come to my own conclusions, but, a
point in the right direction would really be appreicated.


Thanks.

Mark MCSE

 

[Mark Reed MCSE]

Sorry!

I'm after some web pages or those with some general advice on this.