Hi,

Im having difficulties when running a query which appends 3-5000 records into a linked SQL Server6.5-database -table.
IM using an Access database in which I linked some SQL Server Databases. The message Im getting is " Query timeout". I maximized them timeout interval and im still getting that message. However, when I selected the top 1000 records for appending , the query ran fine.When I increased the number of records for appending to 2000 it failed again.
Do you have any suggestion?
Thank you very much for your help.

Vlad