bfreescott
Board Regular
- Joined
- Aug 6, 2015
- Messages
- 115
Whether we're talking about ADO or DAO, the best use case for me has been querying data sets, some of which are Excel files.
As long as the data source exists on the same network, the speed of ADO over an ACE connection far outperforms a WORKBOOK.open approach.
I've noticed however that when executing the same query over a VPN connection, the data source downloads to the client PC anyway, thus completely negating the speed of the ADO approach.
Has anyone faced this challenge and what solution did you find?
As long as the data source exists on the same network, the speed of ADO over an ACE connection far outperforms a WORKBOOK.open approach.
I've noticed however that when executing the same query over a VPN connection, the data source downloads to the client PC anyway, thus completely negating the speed of the ADO approach.
Has anyone faced this challenge and what solution did you find?