[AccessD] Difference between Access ADP and Access MDB with SQLlink

I suppose my question should have been.
Which one is the better ADP or MDB with SQL ODBC ?

Liam

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: 26 September 2003 18:29
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Difference between Access ADP and Access MDB with
SQLlink


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



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com