[AccessD] Problem of a listbox's response on network... Part 1

Thanks Jim - and this implies anyone migrating from MDB to Oracle or SQL
Server has a complete rewrite on their hands as far as VBA-based data
retrieval, correct ?

>
> Hi Mark:
>
> It does depend on where your program is pulling data.
>
> There is no substitute for speed when a local DAO connection is pulling
> and displaying a single record or small group of records from a local
> MDB database but have a DAO connection download 15K of records from a
> remote server and fill a table with the results...
>
> An ADO connection can do that in one to two seconds. It is like
> comparing a sports car to an 8 wheel semi, when it comes to moving
> data.
>
> Jim