I am using ADO through Excel to get at several large oracle databases.

One of the things I am doing is extracting data from the database and transforming it into xml. (I am stuck with oracle 8 so I can't do this database end).

What seems to be happening though is that the machine locks up whilst
rs.open ... is executing. I have tried to use the adAsyncFetch option in the open command and then the FetchProgess event however I can not seem to get processing of rows and the retrieval to tie up.

I always seem to get to the point that the app is trying to process a row that has not yet been returned.

If I was doing this in any other language, I would probably use different threads but I guess I am a little stuck with this if I am using VBA.

Any ideas, comments, pointers ??