Disconnect ignores changes to the DB Ms Access

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Cursor.close()
2.Connection.close()
3.

What is the expected output? What do you see instead?
When Connect see previous changes

What version of the product are you using? On what operating system?
Windows : XP
pyodbc  : pyodbc-3.0.5.win32-py2.7.exe
Python  : 2.7.1
MsAccess: 2000

Please provide any additional information below.
variables are set before executing below:
dbCon=pyodbc.connect('DSN=MS_ACCESS;DBQ='+dbDir+PWD='+str(dbPassword)+';autocomm
it=True') 

Original issue reported on code.google.com by chalho...@hotmail.com on 17 Apr 2012 at 6:48

[GoogleCodeExporter]

Hi, I think if you  change your connection to 

dbCon=pyodbc.connect('DSN=MS_ACCESS;DBQ='+dbDir+PWD='+str(dbPassword),autocommit
=True) 

would solve the problem.

Original comment by jiangwen...@gmail.com on 18 Apr 2012 at 11:00

[GoogleCodeExporter]

Thank you jiangwen it worked

Original comment by chalho...@hotmail.com on 18 Apr 2012 at 1:37

[GoogleCodeExporter]

Original comment by mkleehammer on 27 Sep 2012 at 8:35

• Changed state: NoFix