>
>The SQL is executed each time for a different database, there are 7 locations, these were originally remote, however it was mentioned network traffic would play too much a key part in this, so I setup 7 local databases on a local servre and just accessed them individualy, the SQL is doing the same thing over and over, but for seperate DBF's.
>

Kevin,
Either I never saw your code (thought it was the one as a reply to Terry) or you're not aware yet you're repeatedly (7 times from your saying) executing the same SQL on same tables
Maybe you set this test up wrong from the start.
Cetin