My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 44: Cannot reliably INSERT into Access db if
2 people starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by abbconsu...@gmail.com, Apr 5, 2009
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.


Powered by Google Project Hosting