Posted by VIPS on 11/24/05 17:25

What can be done here is to ask your system dba whether the statistics
on the tables that the query uses is updated recently. In case they are
not, ask the dba to
enable the statistics and create a job the will update statistics on a
weekend when the server is not too busy.

Another option is to use a query analyzer and see what the query plan
is like. If the plan indicates that it is using a table scan, ask have
the dba create relevant index on a table and update and set statistics
on.


On a side note, Access connection to Sql Server that you have is fairly
easy to set up however the TABLE LINKING" method is the slowest as it
hauls not just relevant records but a page amount of record at a time.

If you can do your insert using Connection in the ADO in your forms, it
would be the guaranteed fastest method without any doubt. This is
because you will bypass the virtual table in Access, and will be using
sql server indexes automatically and server processor.

[Back to original message]