[2005] Transactions & Access

I'm using a transaction when inserting new data in the database. What my program does is read info from a txt file and inserts it to the database. It reads fine and was working fine but now for some odd reason, when it is done inserting and I call for Commit, it tells me that the transaction is no longer usable because it has already completed. Can anybody tell me why this is happening?

Moved to Database Development

anybody?