[AccessD] Difference between Access ADP and Access MDB with SQL link

You might want to check you have indexing on your SQL tables
If you don't have a copy of EM Enterprise Manger from full version of 
SQL or know your way around osql, try this free replacement.
http://www.asql.biz/DbaMgr/DownLoad2k.shtm

Liam Meadows wrote:

> I have started to rewrite an application in ADP which has been a bit 
> of a pain but today I had a mess about and created an MDB with a SQL 
> ODBC link to the data and on one particular form which has a filtered 
> list on it the ADP version is about 3 times slower and bringing the 
> list in where as the MDB with ODBC SQL link flies.
> I'm lead to believe that a normal MDB when accessed across a network 
> will transport all the data to the local machine first before running 
> is this true of SQL link ?
>  
> Regards
>  
> Liam