arrays or queries??

[jjmclell]

Hi there,

I have a bunch of data in Access and I'm writing a program that will use that data. What I'm wondering is which is the best way to go...

Should I build my application in Access VBA and use queries to retrieve the data from the tables whenever I need it, or should I populate arrays in my program with the data?

If I were to populate arrays with the data, one array would have 40,000+ records. My main concern is speed as my program will perform ~1,000,000 iterations and will need to call data each iteration.

Thoughts?

jjmclell

 

[SkipVought]

Hi,

I use MS Query and ActiveX Data Objects in Excel to access data from MS Access and other databases.

No, I would NOT import the entire table. Rather query the subset the matches your criteria, just as you might in MS Access in a query.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]