How Python connects an Access database

When you connect to an Access database, it's not that hard. But the constant error.

Win32com ODBC has been tried, or not,

Finally through the link: http://en.wikibooks.org/wiki/Python_Programming/Database_Programming

Pyodbc to solve the problem, the key factor is the support of the SQL statement, must write very specification, such as join must be written inner join and so on.

Error message: Programmingerror: (U ' 42000 ', U ' [42000] [Microsoft][odbc Microsoft Access \u9a71\u52a8\u7a0b\u5e8f] from \u5b50\ U53e5\u8bed\u6cd5\u9519\u8bef\u3002 ')

Base code:

Import pyodbc 
dbfile = '/data/msaccess/music_library.mdb '
conn = Pyodbc.connect (' Driver={microsoft Access Driver (*.mdb)};D bq= ' +dbfile)
cursor = conn.cursor ()
 
SQL = ' SELECT Artist, albumname from Recordcollection order By year; ' For row in Cursor.execute (SQL): # cursors are iterableprint row. Artist, Row. Albumname
 
cursor.close ()
conn.close ()