How to execute Multiple Sql Statements?

Hello I am new to VB programming, Currently I am facing one Problem in executing multiple SQL Queries through Connection Object.

My situation is like this,
i want to transfer records from one Mdb file to another. for that i have created one transfer function that calls other functions. now while tranferring, if i debug the entire code, then it transfers records from one Mdb to another, but if i run code directly onPress of command button, records remains as it is in the same Mdb without transfer,

its really strange for me that code runs perfectly in debug mode but not while running program. i think there should be some buffer or other properties or attributes that i have to set for that, but i dont know how to solve this problem,
please anybody help in this problem.

Welcome to the forums. :)

If you could please post the code you are using to do the record transfer, perhaps a solution will present itself. Without knowing how you are doing what you are doing, any comments would be pure speculation.

From what I've seen of my own bugs, when something doesn't work in .EXE that works while stepping through code in IDE, then it's event related - some event is firing or not firing properly.

Does it always work in the IDE - even if RUN without stepping?