L Larry Linson Jul 6, 2004 #2 What is faster for a big base? Will it be that makes difference? Click to expand... In general, Queries are faster than VBA/DAO code, especially for large amounts of data. In specific, one just has to test to see if your particular situation is a rare exception. But, I'd bet on the Query being faster the vast majority of the time. Larry Linson Microsoft Access MVP
What is faster for a big base? Will it be that makes difference? Click to expand... In general, Queries are faster than VBA/DAO code, especially for large amounts of data. In specific, one just has to test to see if your particular situation is a rare exception. But, I'd bet on the Query being faster the vast majority of the time. Larry Linson Microsoft Access MVP
