As many people we also converted an Access database into an SQL database and
an Access frontend. When we moved to SQL we noticed that the performance of
the frontend was decreased. With a lot of views on the SQL database we
managed to get the same performance, but I'm still didn't solved it.

When I just get a table in three different cases 1 from my hard disk with an
access database, 2 from a file server with an access database an 3 with ODBC
from the SQL server the last one is the slowest.

Can some tell me why this is so, and how I van solve the performance I've
lost.

Stephan Beersma