I'm just trying to get started with a MS Access 2000 project and right off the bat I have a problem which I cannot solve. If I do a series of "INSERT INTO testTable2 (num, name) VALUES (111, 'name1') statements. All records except the last are added. I searched for similar post and found none, only a post concerning a delay, which is not the problem. No matter how many INSERT INTO statements I use the last is not added. What is wrong or needs to be changed? Any directions on this will be greatly appreciated. Thanks.