Hello I have two sql statements that run one right after another to append records to an ms access table from another table. The problem is that if I let them run immediately after each other only the first one gets through correctly, but if I put a 5 second timer between each append, they all go in. Why is this and is there a fix?

code that fails:
cn.execute strSQL1
cn.execute strSQL2
cn.execute strSQL3
cn.execute strSQL4

code that works:
cn.execute strSQL1
sleep(5)
cn.execute strSQL2
sleep(5)
cn.execute strSQL3
sleep(5)
cn.execute strSQL4


sleep(x) is a function I wrote that uses a timer object to pause for 5 seconds.

Thanks,
Thai