access linked to odbc sql database

[swamp]

Hi,

i've converted a access 97 database to an sql database

linked all the tables to the access program
all problems solved etc and mostly the program runs a lot
faster compared to the old access database

However some query's take more than normal time to give
back the results

can anyone tell me where I should pay attention to
in order to speed up these query's ?

thanks in advance
Miguel.

 

[Mary Chipman]

Fetch only needed data and don't bind forms to entire tables. Open a
Profiler trace to see what's going on. Cache static data in local
tables and use those to populate combo boxes and list boxes. Write
stored procedures for reports or other read-only data and execute them
via passthrough queries.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446