Cannot reliably INSERT into Access db if

What steps will reproduce the problem?
I'm trying to do simple INSERTs into an Access 2007 (.accdb) database which
is connected via ODBC. I noticed that if I attempt to insert multiple rows
one after the other into a table, the last row does not get inserted. This
happened to me only if I set autocommit=True when creating the db
connection. The problem does not happen if the commits are performed
manually. No errors were ever returned.

What version of the product are you using? On what operating system?
pyodbc-2.1.3.win32-py2.6 on Windows XP x64

Please provide any additional information below.
This was really frustrating. I wonder if the problem has to do with pyodbc
or the ODBC Access driver. I find autocommit=True to be really useful for
simple transactions, and I'd prefer not having to do the commit manually
for these.

Original issue reported on code.google.com by abbconsu...@gmail.com on 5 Apr 2009 at 8:40

tanrj / pyodbc

Cannot reliably INSERT into Access db if #44