Not Responding on selection

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.

What dbs are you using?

The DBS I'm using is MS SQL 6.5 .. I'm also using VB 5.0 using RDO.

-- mace

Hi all.

Actually I figured it out. Thanks to joedoer for your interest in helping me out.

-- mace