Hi.

I'm writing an application that will import a recordset (depending on the selection criteria) from one db table to another db table. However, my application seems to stop responding when I'm selecting from a large database. Is there a way to get this to work? I check the table after I kill the process and it does insert the some of the recordset. The problem is, it is nowhere near completion.

Note: The databases are located in different servers.

Any and all help is appreciated. Thanks.