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.