<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=545101513-26092003>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=545101513-26092003>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
?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=545101513-26092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=545101513-26092003>Regards</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=545101513-26092003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=545101513-26092003>Liam</SPAN></FONT></DIV></BODY></HTML>